UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Format leading zero's in Excel    
 
   
bakersburg9
post Jan 19 2007, 11:14 AM
Post #1

UtterAccess Ruler
Posts: 4,237
From: Downey, CA
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
Go to the top of the page
 
+
KingMartin
post Jan 19 2007, 11:28 AM
Post #2

Retired Moderator
Posts: 10,959
From: Prague,CZ / Kiev,UA
Hi Steve,

have a look at TEXT() function... (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

Martin
Go to the top of the page
 
+
Thorin
post Jan 19 2007, 11:28 AM
Post #3

UtterAccess Addict
Posts: 280
From: Suffolk, England, UK
Try : -

=CONCATENATE(TEXT(F1,"0000"),TEXT(F2,"0000"),TEXT(F3,"0000"))
Go to the top of the page
 
+
bakersburg9
post Jan 19 2007, 11:33 AM
Post #4

UtterAccess Ruler
Posts: 4,237
From: Downey, CA
Martin, Andy:

Thanks !

Steve
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 01:25 AM