Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format need to display 0001 etc
Is there any way to format this other than formatting as text
I'd be grateful if anyone has an answer -- Carys |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format need to display 0001 etc
Carys wrote: Is there any way to format this other than formatting as text I'd be grateful if anyone has an answer -- Carys Hi Carys Select your cell range. Format Cells. Under Category, click Custom. In the Type field, enter 0000. Click OK Regards Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format need to display 0001 etc
Use a custom format of: 0000
?????? Carys wrote: Is there any way to format this other than formatting as text I'd be grateful if anyone has an answer -- Carys -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format need to display 0001 etc
Thanks Steve
-- Carys " wrote: Carys wrote: Is there any way to format this other than formatting as text I'd be grateful if anyone has an answer -- Carys Hi Carys Select your cell range. Format Cells. Under Category, click Custom. In the Type field, enter 0000. Click OK Regards Steve |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number format need to display 0001 etc
Thanks Dave.
Works a treat -- Carys "Dave Peterson" wrote: Use a custom format of: 0000 ?????? Carys wrote: Is there any way to format this other than formatting as text I'd be grateful if anyone has an answer -- Carys -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel default number format problem | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Time format to number while keeping value | Excel Worksheet Functions | |||
How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |