taduh
asked on
How to write accurate fully qualified numerical data to an ascii file from Excel using VBA
Hey Experts,
I am trying to create an ASCII file from data on an Excel spreadsheet using VBA code. Everything is working wonderfully except that large numbers are being formatted on the file with scientific notation and some of the numbers are having their decimal places rounded. These are monetary amounts so I need them to be 2 decimal places as represented in the spreadsheet.
Any ideas about how to get the data written to the ASCII file as formatted on the spreadsheet?
Thanks,
taduh
I am trying to create an ASCII file from data on an Excel spreadsheet using VBA code. Everything is working wonderfully except that large numbers are being formatted on the file with scientific notation and some of the numbers are having their decimal places rounded. These are monetary amounts so I need them to be 2 decimal places as represented in the spreadsheet.
Any ideas about how to get the data written to the ASCII file as formatted on the spreadsheet?
Thanks,
taduh
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.