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

[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!

 

[Trevor]

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.