concatenate format

G

Guest

I am trying to concatenate custom fields with formats: 00, 00, 000.
Concatenate function removes the custom formatting so for example
concatenating values 01, 00, 001 returns 101 when what I want is 0100001.
How can I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate function 2
Help with Concatenation 3
How specify number format of cell value in concatenate function? 1
Peculiar default cell format 1
Custom Format or use function? 4
Excel: How do you format numbers in a concatenate string? 8
Payment calculation 1
How do you combine a date field and a time field into one? 6

Top