Displaying insignificant numbers in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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