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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Importing number - want to convert to standard    
 
   
djbosch
post Aug 23 2007, 09:11 PM
Post #1

UtterAccess Addict
Posts: 209
I am importing a text file with a number field - the imported number looks like 1532489, I would like to format it so that is looks like: 15324.89. Any ideas?

Thanks,
Denise
Go to the top of the page
 
+
freakazeud
post Aug 23 2007, 09:29 PM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
Hi,
how about:

1532489 / 100

?
HTH
Good luck
Go to the top of the page
 
+
djbosch
post Aug 23 2007, 09:30 PM
Post #3

UtterAccess Addict
Posts: 209
Nevermind - I'm too busy looking for a function, while I overlooked the obvious - /100.....
Go to the top of the page
 
+
djbosch
post Aug 23 2007, 09:30 PM
Post #4

UtterAccess Addict
Posts: 209
Thanks - I had just figured that out...
Go to the top of the page
 
+
freakazeud
post Aug 24 2007, 08:36 AM
Post #5

UtterAccess VIP
Posts: 31,413
From: NC, USA
You're welcome (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)
Good luck on future projects!
Go to the top of the page
 
+
« Next Oldest · Access Automation · 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: 19th May 2013 - 09:15 PM