Numeric Format

[Daniel]

I am writing a text file with numbers which I would like in E16.9 fortran
format, example:
-4.543785477E+01
1.675241709E+00

both positive and negative have 16 characters per number (the positive
includes the space instead of the - sign)

how can I do this with format (mynumber, ???)

is there any other way?
thanks
Dan

 

[JLGWhiz]

Format>Cells>Scientific

 

[JLGWhiz]

For VBA: MyRange.NumberFormat = "Scientific"

 

[Daniel]

thanks guys but it returns numbers with an additional character due to the -
sign