Custom format of numbers

[Huffy]

Hi all... and many thanks to a lot of the posts I've been through already to help me out!

What I'm looking to do now in my macro is a custom format of a group of cells to display 5 numbers. Example output would be:

10141
04039
00583
92584
35412
99919
00098

The zeros must be displayed. The cells are formatted as numbers, but of course, the zeros that begin the numbers disappear.

 

[Joe4]

Welcome to the Board!

If you format as Text instead of Number, the leading zeroes will not be dropped. Formatting the cells as Text before populating should do the trick, as long as your code isn't trying to insert a number that has already dropped the leading zeroes.

If so, you can convert it in VBA using:
FORMAT(Value,"00000")