M
Matt
How do I display the number 00036 as such instead of excel
automatically formatting it as 36?
automatically formatting it as 36?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Try
Format|Cell|Custom and use a custom format of 00000
Mike
Format|Cell|Custom and use a custom format of 00000
Mike
D
Dave Peterson
You could give the range of cells a custom format:
Select the range
format|cells|Number tab|custom category
type: 00000
You could preformat the cell as Text and type 00036
You could start your entry with an apostrophe: '00036
The last two will treat your entry as text--not a number.
Select the range
format|cells|Number tab|custom category
type: 00000
You could preformat the cell as Text and type 00036
You could start your entry with an apostrophe: '00036
The last two will treat your entry as text--not a number.
S
Stevenb33
You can right click on the cell, format cell, and select that cell
type as "text".
type as "text".
D
David Biddulph
But that won't help if you've already entered the number. Formatting as
text is fine if you do it before you enter the number.
text is fine if you do it before you enter the number.