Thread: How do I show a "0" before a series of numbers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
  
Posts: 430
Default How do I show a "0" before a series of numbers?
See if this works:

'format'...'cells'...'custom' in the little window below 'Type' put 0###

format the cell 1st and then try typing 123 in the cell


"Caryn Frank" wrote:

In excel I am trying to type 0123 but the 0 is not showing - What do I do?
Reply With QuoteReply With Quote