Thread
:
How do I type a # (01020) in Excel & have the 1st 0 stay?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Domenic
Posts: n/a
How do I type a # (01020) in Excel & have the 1st 0 stay?
Precede the entry with a single quote...
'012345
Or format the cell as 'Text'.
Hope this helps!
In article ,
Teresa-Hot Iron <Teresa-Hot
wrote:
I am trying to do a spread sheet in Excel that requires me to put in item
numbers that begin with the number 0. However, when I type in the # and hit
enter, the 0 goes away. How do I format the cells to keep the 0?
Thanks!!
Reply With Quote