I am trying to concatenate 3 fields :

F1.......F2........F3
==......==......==
7443....9933...0015

but it comes out 7443993315

i want : 744399330015

In access query, I could do this:
Format([MyNumberField], "0000")

what would be the relevant syntax or custom formatting in Excel ?

I tried ############ and 000000000000 and niether worked

Hi Steve,

have a look at TEXT() function...

Martin

Try : -

=CONCATENATE(TEXT(F1,"0000"),TEXT(F2,"0000"),TEXT(F3,"0000"))

Martin, Andy:

Thanks !

Steve