Excel

  • Thread starter Thread starter John Stech
  • Start date Start date
J

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.
 
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.
 
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
 
Back
Top