how to display zero prefixes in worksheet cells such as phone numb

B

bomber bob

I want to know how to display a phone number with a zero prefix or a series
of digits with a prefix of zero e.g 0427. When I input 0427 the cell shows
427.
 
J

Jacob Skaria

Format the cells to 0000. Right click>Format Cells>From the list select
'Custom' and enter 0000 in Type field. This will make sure the number you
enter is always displayed as 4 digits..
 
Top