Thread: Numeric Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Numeric Format

FormatCellsScientific

"Daniel" wrote:

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