View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Number Entry in Excell

Either pre-format the cell as TEXT, or type a leading apostrophe before the
first zero. The apostrophe will not show up in the cell but automatically
formats that cell as TEXT.

Vaya con Dios,
Chuck, CABGx3



"viper2000ss" wrote:

How do I enter numbers that start with zero i.e. 01-1-5121? Every time I
enter a number like the one previously noted, it changes.