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.
|