Numeric Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 10 Dec 2007 15:39 GMT

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

Reply to this Message

JLGWhiz - 10 Dec 2007 15:55 GMT

Format>Cells>Scientific

> I am writing a text file with numbers which I would like in E16.9 fortran
> format, example:
[quoted text clipped - 9 lines]
> thanks
> Dan

Reply to this Message

JLGWhiz - 10 Dec 2007 15:58 GMT

For VBA: MyRange.NumberFormat = "Scientific"

> I am writing a text file with numbers which I would like in E16.9 fortran
> format, example:
[quoted text clipped - 9 lines]
> thanks
> Dan

Reply to this Message

Daniel - 10 Dec 2007 16:13 GMT

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

> For VBA: MyRange.NumberFormat = "Scientific"
>
[quoted text clipped - 11 lines]
> > thanks
> > Dan

Reply to this Message