I need to write a text file with numbers in the format 5E16.9.

I have the numbers already in an array (i,j) in VBA (they are not in a
workbook cell):

columntext = arr(i, j)

how do I request these numbers to be formatted 5E16.9?

thanks
Dan

Do you want a numeric result or a string result?

for a string
enumber = format(mynumber,"scientific")

To change the format of the wroksheet cell for scientific

Range("A1").NumberFormat = "0.00E+00"



"Daniel" wrote:

I need to write a text file with numbers in the format 5E16.9.

I have the numbers already in an array (i,j) in VBA (they are not in a
workbook cell):

columntext = arr(i, j)

how do I request these numbers to be formatted 5E16.9?

thanks
Dan

Joel,
it it a string,
it worked
thanks, happy holidays
Dan

"Joel" wrote:

Do you want a numeric result or a string result?

for a string
enumber = format(mynumber,"scientific")

To change the format of the wroksheet cell for scientific

Range("A1").NumberFormat = "0.00E+00"



"Daniel" wrote:

I need to write a text file with numbers in the format 5E16.9.

I have the numbers already in an array (i,j) in VBA (they are not in a
workbook cell):

columntext = arr(i, j)

how do I request these numbers to be formatted 5E16.9?

thanks
Dan