Posted to microsoft.public.excel.programming

external usenet poster

Posts: 16

concatenate problem

Help Urgent

I have a column with variable length numbers. I need to put these in a new
column with leading zeros in front to make the length of the new cell to 10.
Example for cell with 23, I need a new column to hold 0000000023.
--
Lindy

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
Concatenate Problem	John Calder	New Users to Excel	7	April 2nd 08 01:11 AM
CONCATENATE problem	Mark Dullingham	Excel Worksheet Functions	6	March 6th 07 12:11 AM
Concatenate Problem	John Calder	New Users to Excel	3	November 13th 06 10:39 PM
Concatenate Problem	EW	Excel Programming	4	July 6th 06 11:51 PM
concatenate problem	joe peters	Excel Worksheet Functions	9	May 29th 05 06:34 AM

All times are GMT +1. The time now is 07:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us