Add a Zero

[DaveB]

I need to add a zero in front of 3,000+ different
records...is there a way to do them all at once. Thanks.
DaveB

HAVE:
Cell A1: 60244
Cell A2: 82774
Cell A3: 17863

WANT:
Cell A1: 060244
Cell A2: 082774
Cell A3: 017863

 

[Frank Kabel]

Hi
- select the cells
- apply the following custom format to these cells:
000000