leading zeros - exporting

  • Thread starter Thread starter karen mitchelld
  • Start date Start date
K

karen mitchelld

I have a fellow associate who is attempting to export an
Access 97 file to Excel 97. When she does, her leading
zeros are lost. Does anyone have a suggestion? Thanks!
 
What's the difference between the numbers 1 and 000001?

Nothing!

It is only the display that looks different. In Access, you can format the
numbers with leading zeros and the same in Excel (Format / Cells / Number /
Custom).

If your associate want to export "000001" as a Text Field to retain the
leading zeros, then create a Query a replace the Number Field with a
Calculated Field:

NumberAsText: Format([YourField], "000000")

(or whatever the formatting String required) and then export the Query
rather than the Table.
 
Back
Top