displaying leading zeros

[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

 

[Pete_UK]

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

 

[blkane]

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.

 

[Pete_UK]

Glad it worked for you - thanks for feeding back.

Pete