software

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
You can use a custom format of
00000000000

your entries will then be numeric, right justified by default,
and the fill handle will fill down. Numbers are limited to
15 significant digits.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;dfgquot; gt; wrote in message ...
gt; hi there
gt;
gt; i need to insert a zero in front of a range of numbers
gt;
gt; 7011117050
gt; 7011117051
gt; 7011117052
gt; 7011117053
gt;
gt; also they will not drag to the next number in sequence
gt;
gt; thanks
gt;
gt;