| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate 2 different number formats
I am trying to create a string of numbers from 2 different number formats.
The formula I am trying is on test tab 3 =concatenate("T",Test1!A1,Test1!A2). I have created custom format 00000000 for A1 and custom format 000000000000 for A2. A1 has 000000006 A2 has 000001212422 I would like it to return T000000006000001212422 but it returns T61212422. Any ideas on how to make it work? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get different text formats in a concatenate function | Excel Discussion (Misc queries) | |||
| number formats after concatenate | Excel Worksheet Functions | |||
| number formats after concatenate | Excel Worksheet Functions | |||
| How to Concatenate with a text & number | Excel Worksheet Functions | |||
| concatenate number format issue | Excel Worksheet Functions | |||
Threaded Mode
