| 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
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 |
|
#4
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 |
|
#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) | |||
Hybrid Mode
