Prevent Scientific / Exponential Notation (in CStr) ?

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:

Please Login or Register  to view this content.

Feedback welcome, particularly as regards things to watch out for, or a simpler programmatic solution
(i.e. - turning off the friendly notation).

Thanks,

- Richard

could you attach any workbook with dummy data to export ?
And present how finally your text file should looks like ?

I don't know if you will ever see that reply but here is a way to do this without looping

Please Login or Register  to view this content.

in attached file you will find working example