Greetings -
I need to create a text .psv (Pipe Separated Value) file from Excel percentage data
with ~15 significant digits (e.g. - 87.1083154822352%, 0.0720306042793482%).
No matter what formatting I try, using VBA to create a string from this data
(using either Str or CStr) generates undesired scientific notation
(e.g. - 1.12345678901234E-04) for several of the data points.
So, I wrote a bit of code to parse that notation:
Feedback welcome, particularly as regards things to watch out for, or a simpler programmatic solutionPlease Login or Register to view this content.
(i.e. - turning off the friendly notation).
Thanks,
- Richard
Bookmarks