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
|