displaying leading zeros

  • Thread starter Thread starter blkane
  • Start date Start date
B

blkane

Is there a way to display leading zeros in a number and still have it
formatted as a number? We have account numbers for customers that often
start with a zero. When analyzing activity in Excel, the leading zeros are
dropped. It would be helpful if they would show.

Thanks
 
Apply a custom format to the cells of 00000000 to display the numbers
as 8 digits, with leading zeros where appropriate.

Hope this helps.

Pete
 
Perfect! I knew there was an easy answer. I use a lot of complicated
formulas but it is usually the small stuff that hangs me up.
 
Back
Top