Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 184

Concatenate with leading zeros

I need to input a formulat to concatenate three cells together. The first
cell is a nine digit number ex. 001234567 the second cell is a one digit
number ex. 8 and the third cell is a five digit number ex. 00123. I how do I
concatenate these together?
--
Nikki

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
How can I concatenate text with leading zeros	Dick	Excel Worksheet Functions	2	January 31st 08 06:36 PM
Leading Zeros	Ben Watts	Excel Worksheet Functions	8	September 26th 07 05:44 PM
add leading zeros	Jacqueline	Excel Worksheet Functions	2	July 12th 06 06:46 PM
save text field w/ leading zeros in .csv format & not lose zeros?	Ques	Excel Discussion (Misc queries)	1	May 4th 05 06:21 PM
Leading zeros	JC	Excel Discussion (Misc queries)	9	February 1st 05 02:33 PM

All times are GMT +1. The time now is 05:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us