hi there

i need to insert a zero in front of a range of numbers

7011117050
7011117051
7011117052
7011117053

also they will not drag to the next number in sequence

thanks

see other post.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"dfg" wrote in message ...
hi there

i need to insert a zero in front of a range of numbers

7011117050
7011117051
7011117052
7011117053

also they will not drag to the next number in sequence

thanks

Hi,

select the cells you want to add the zero in front, right-click
-format cells-custom- type in "0"0 for the custom format.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544254

It depends what you need

If you format the cell custom 00000000000 it will insert a 0 at the
front of the cell. If it needs to be dragged down, you need to slect 2
cells to make it increment

Otherwise in another cell
="0"&a1
It can then be selected and copied on top of itself as values, but it
will be text

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=544254