| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying insignificant numbers in a cell
Does anyone know how to create a function in Excel that will allow
insignificant zeroes to show before a number? F or example if I want all of my cells to display four digits (1,324) but one entry is 897, how can I make the cell view it like 0897? Is this possible? Thank you so much. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying insignificant numbers in a cell
Try a custom format of
0000 Mike "Genie" wrote: Does anyone know how to create a function in Excel that will allow insignificant zeroes to show before a number? F or example if I want all of my cells to display four digits (1,324) but one entry is 897, how can I make the cell view it like 0897? Is this possible? Thank you so much. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying insignificant numbers in a cell
Custom format to 0000
Gord Dibben MS Excel MVP On Fri, 19 Oct 2007 04:09:08 -0700, Genie wrote: Does anyone know how to create a function in Excel that will allow insignificant zeroes to show before a number? F or example if I want all of my cells to display four digits (1,324) but one entry is 897, how can I make the cell view it like 0897? Is this possible? Thank you so much. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying insignificant numbers in a cell
Thank you so much!
"Mike H" wrote: Try a custom format of 0000 Mike "Genie" wrote: Does anyone know how to create a function in Excel that will allow insignificant zeroes to show before a number? F or example if I want all of my cells to display four digits (1,324) but one entry is 897, how can I make the cell view it like 0897? Is this possible? Thank you so much. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying insignificant numbers in a cell
Thank you.
"Gord Dibben" wrote: Custom format to 0000 Gord Dibben MS Excel MVP On Fri, 19 Oct 2007 04:09:08 -0700, Genie wrote: Does anyone know how to create a function in Excel that will allow insignificant zeroes to show before a number? F or example if I want all of my cells to display four digits (1,324) but one entry is 897, how can I make the cell view it like 0897? Is this possible? Thank you so much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying -ve numbers | Excel Discussion (Misc queries) | |||
| Displaying all numbers as positive | Excel Worksheet Functions | |||
| format a cell for displaying numbers in lakhs | Excel Discussion (Misc queries) | |||
| How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
| Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
Linear Mode
