Posted to microsoft.public.excel.misc

dfg

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reference the same row from another sheet after inserting a new ro	Brian	Excel Worksheet Functions	1	April 2nd 23 12:54 PM
Inserting multiple rows	syssupspe	Excel Discussion (Misc queries)	3	January 13th 06 05:06 PM
Inserting Objects	BeanyBabe	Excel Discussion (Misc queries)	1	December 19th 05 10:38 PM
Separate 5digits by inserting -	Faio	Excel Worksheet Functions	4	December 1st 05 03:17 AM
Inserting Footer - Ajit	Ajit Munj	Excel Discussion (Misc queries)	2	March 11th 05 02:39 PM

All times are GMT +1. The time now is 03:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us