Excel

[John Stech]

I work with numbers that have leading zero's. Excel
constantly drops the leading zero's is there a way to stop
this. Ex type 01111 in a cell and it drops the zero. If I
past 01111 into Excel for Access it keeps the zero's but
doing some function will then drop the zero again.

 

[Lady Layla]

Format the fields as text


: I work with numbers that have leading zero's. Excel
: constantly drops the leading zero's is there a way to stop
: this. Ex type 01111 in a cell and it drops the zero. If I
: past 01111 into Excel for Access it keeps the zero's but
: doing some function will then drop the zero again.

 

[Andrew Lewis]

or if all the number are a fixed length you can go to
Format>Cells>Custom and type in the desired number length
in zeros
ie for a 5 digit number 00000, and apply the same to the
other columns if needed