show 0 in front of number in Excel 0678
 

trying to enter a number that starts with a zero, and would like the zero to
stay. ie 0678

show 0 in front of number in Excel 0678
 

Two ways:

1. precede your entry with an apostrophe (single quote)
2. Format Cells... Number Custom
0000

You can apply the second method to data already entered.
--
Gary's Student
gsnu200706


"George" wrote:

trying to enter a number that starts with a zero, and would like the zero to
stay. ie 0678