ExcelBanter - inserting zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - inserting zero (https://www.excelbanter.com/excel-worksheet-functions/89835-inserting-zero.html)

dfg

inserting zero

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

Bob Phillips

inserting zero

Format as 00000000000

--
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

All times are GMT +1. The time now is 05:40 AM.