Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formats
How do I display the number 00036 as such instead of excel
automatically formatting it as 36? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formats
Try
Format|Cell|Custom and use a custom format of 00000 Mike "Matt" wrote: How do I display the number 00036 as such instead of excel automatically formatting it as 36? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formats
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. Matt wrote: How do I display the number 00036 as such instead of excel automatically formatting it as 36? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formats
You can right click on the cell, format cell, and select that cell
type as "text". On May 17, 8:42 am, Matt wrote: How do I display the number 00036 as such instead of excel automatically formatting it as 36? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formats
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. -- David Biddulph wrote in message ups.com... You can right click on the cell, format cell, and select that cell type as "text". On May 17, 8:42 am, Matt wrote: How do I display the number 00036 as such instead of excel automatically formatting it as 36? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom number formats | Excel Discussion (Misc queries) | |||
Outline different number formats | Excel Discussion (Misc queries) | |||
Custom Number Formats - Help | Excel Discussion (Misc queries) | |||
number formats | Excel Worksheet Functions | |||
Phone Number Formats | Excel Discussion (Misc queries) |