View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Domenic
 
Posts: n/a
Default 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!!