Formatting .CSV File

[richrock316]

My program creates a .CSV file and outputs 20 or so fields to it. The problem is that in the .CSV file it sets all the fields to a "general" category. This means when I wanted a value of 115.200, I get 115.2 . Is there any way of formatting it from code to include the proper amount of decimal places.

Currently I am using a format of: Format(ITIME , ".000")

 

[Error7]

I would use 'MyField = Format(MyValue, "###.000")'

Though other members may have a different approach.

Alan



[gray]Experience is something you don't get until just after you need it.[/gray]

 

[richrock316]

Alan,

I still get the same results. It won't keep the trailing zeros.

Richard

 

[Error7]

Richard,
I suspect you are opening the file with Excel. If so it is Excel that is removing the zeros.

If you open the file with Notepad you will see that the zeros are actually included.

Alan

[gray]Experience is something you don't get until just after you need it.[/gray]

 

[richrock316]

Alan,

Yes I am using Excel to open it. It is how the user will open it.

Richard

 

[Error7]

Richard

Sorry but the only way round it that I know of is to format the Excel cell to 'Number' with 3 decimal places.

Hopefully somebody else will chip in with a better solution.

Alan

[gray]Experience is something you don't get until just after you need it.[/gray]