How do I use CDbl to display as a actual number not in E notation

[Eric]

I am trying to set up in access a macro that concatinates three parts of an
account number into the whole 14 digit act number. Since the concatinate
function must all be strings we must convert the entire 14 digits to a number
afterward. I am trying to use CDbl to convert it but I just get scientific
notation which doesn't mean much as an account number. The accounting
program we must export these files to want it to be a number not text so just
leaving its not an option any ideas. I REALLY need the help im stuck on this
one.
Thanks

 

[John Nurick]

Hi Eric,

If the accounting program will accept (say)
12345678901234
but not
1.2345678901234E13
or
12345678901234.0
then it's asking for a string of digits and _not_ a numeric value.

It might be worth using CCur() instead of CDbl() - but that won't help
if the accounting program accepts
00000000001234
but not
1234.0000

If you're right that the accounting program requires a numeric value,
using the Format() function won't help, because that takes a numeric
value and returns a string.

So what format are you using to export the data to the accounting
program?