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
Full Version: Importing number - want to convert to standard
Hi,
how about:
1532489 / 100
?
HTH
Good luck
how about:
1532489 / 100
?
HTH
Good luck
Nevermind - I'm too busy looking for a function, while I overlooked the obvious - /100.....
Thanks - I had just figured that out...
You're welcome 
Good luck on future projects!
Good luck on future projects!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.