| 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. |
| 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) | |||
Threaded Mode
