H
Heisall
Guest
Hi,
I received an Excel file with job numbers that read 12345-0010, 12345-0020, 12345-0150, etc... The left side of the dash is the order number and right side is the operation number (of the order). I used the "Text to Columns" feature in Excel to create two separate columns so that A2 became 12345 and B2 became 0010. The format property of the cell containing operation number (0010) is Custom 0000. The length of characters for order and operation is always 5 and 4 respectively.
My problem is that when I import the worksheet from Access 2000 the operation numbers become 10, 20, 150, etc... I can't figure out how to add back the correct number of leading zeroes through table field formatting. And I've tried all I know to play around with the Excel formatting.
Is there an Access query expression I could use to add back the one or two zeroes?
Thanks, Don
I received an Excel file with job numbers that read 12345-0010, 12345-0020, 12345-0150, etc... The left side of the dash is the order number and right side is the operation number (of the order). I used the "Text to Columns" feature in Excel to create two separate columns so that A2 became 12345 and B2 became 0010. The format property of the cell containing operation number (0010) is Custom 0000. The length of characters for order and operation is always 5 and 4 respectively.
My problem is that when I import the worksheet from Access 2000 the operation numbers become 10, 20, 150, etc... I can't figure out how to add back the correct number of leading zeroes through table field formatting. And I've tried all I know to play around with the Excel formatting.
Is there an Access query expression I could use to add back the one or two zeroes?
Thanks, Don
