View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default How to show "0" at the beginning of a number sequence?

You have to make it a text... try adding a singel apostraphe before it... like

='0123

"michelle" wrote:

For example, if I type 0123 in a cell, the "0" disappears and will only show
the 123. How to I disable that auto correction?