Full Version: Format leading zero's in Excel
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
bakersburg9
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
KingMartin
Hi Steve,

have a look at TEXT() function... wink.gif

Martin
Thorin
Try : -

=CONCATENATE(TEXT(F1,"0000"),TEXT(F2,"0000"),TEXT(F3,"0000"))
bakersburg9
Martin, Andy:

Thanks !

Steve
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.