Thread: zero value
View Single Post
  #3   Report Post  
Larry Harman
 
Posts: n/a
Default


-----Original Message-----
How do you add a zero in front of a number in excel

without it disappearing?
.

if the number remains constant ie: 4 digits

1234 you want 01234

Format cell custom 00000

Email me and ill send back an xls to show you.

Larry Harman