Interfacing Excel sheets to get an Access product in the end...

  • Thread starter Thread starter Shaundra
  • Start date Start date
S

Shaundra

I need to enter a number that starts with zero but Excel
keeps omitting it. How can I get it to leave it alone,
and later on I have will link this table in Access but I
need it to be recognized as a number when it gets there.
The data in this table has to be compared with another
and changing its format can't interfere with that. Help!
 
I think if you define a custom format for the cell it
should do the trick.

e.g. number format 00000, 123 would display 00123
e.g. number format 000, 1 would display 001

etc

Hope that helps,

Trevor.
 
Back
Top