Thread: zero value
View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Precede it with an apostrophe or use a custom format like 0000
which would display 0123 if you enter 123 in the cell

--

Regards,

Peo Sjoblom


"Jimmy" wrote in message
...
How do you add a zero in front of a number in excel without it

disappearing?