View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
scottay scottay is offline
external usenet poster
 
Posts: 6
Default how to show numbers that begin with 0 in excel

you need to put a an apostraphe before the number. you should type '0236547

"Dee" wrote:

I need to type numbers into an excel spreadsheet some of them begin with a
zero some do not. How can I have excel show the 0 in the numbers that begin
with 0. If I type 0236547 the number shows as 236547. I don't want all the
numbers I type to begin with zero.

I am using Excel 2003. Thanks very much for your help.

Best regards,

Dee