Full Version: Format leading zero's in Excel
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
bakersburg9
I am trying to concatenate 3 fields :
1.......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.