With Ampersand Extracted from Multiple to a single Cell, HOW TO GET W LEADING ZERO?

Hi this david,

I have the following problem to solve..please need some advice

(I have to Paste in a Daily Basis)
in one Column there are Multiples Cell using 2 Digits (Col:I, R:8~R:41)

Using Ampersand Function I Extracted 6 SETS of 18 Numbers in to 6 Diferent single Rows (Rows:C34, C35,C36,C37,C38 and C39)
(each Row it's holding 18 numbers,I Added a Dash between each numbers)


Everything get Copied with the Ampersand Function, But is not Copy the Leading ZERO,

HOW CAN I ADDED THE LEADING ZERO?"

1-. I ALREADY Went to Format Cell Property's and in Custom I Added double Zero's "00"

2-. I ALREADY Set the Sow ZERO Values in Excel Setting (Show Zero Check mark Option)

3-. I DON'T want to Use As i Text with the Aphostrophe ( ' ) Because i have to Paste the numbers Column
on a daily basis.


For example, in ROW C34 The Function that I Inserted is the Follow :

Please Login or Register  to view this content.

I PASTED THIS :

09
10
12
14
36
19
26
29
31
32
08
15
20
33
01
06
02
07



IM getting this Output--> 9-10-12-14-36-19-26-29-31-32-8-15-20-33-1-6-2-7


I need this Result ------> 09-10-12-14-36-19-26-29-31-32-08-15-20-33-01-06-02-07
(with leading "0"




Thank you !!!!


Best Regards


David

Try this...

Please Login or Register  to view this content.

Thank you Mr AlphaFrog and Mr martindwilson ,

Thanks Work great !!




Best Regards

David