how do i get excel to NOT take zero's of the front of a number

[Bob Phillips]

Use a custom format of say 000000

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Cindy]

Try using an apostrophe before you enter your number. HTH Cindy