Saving Currency In CSV

[Dazzawm]

I have a friend who has a spreadsheet in excel that is in the format of 2.00, 3.00, 4.50 etc. but when he saves it as CSV (he needs to) it chops of the zeros i.e it is 2, 3, 4.5 etc Is there any way it can be saved in CSV the same way it is in excel with the .00? Thanks.

 

[Dazzawm]

^

 

[wigi]

Does your friend open the file again in Excel, or a text editor like Notepad?

If opened in Excel, indeed the 00 are lost.

What is the aim of saving as CSV if it's opened in Excel?

 

[Dazzawm]

I dont know why he needs to save as a CSV and he will be opening again in Excel. So nothing can be done to stop losing the .00s?

 

[Dazzawm]

^

 

[Dazzawm]

Any help anyone please?

 

[snoopyhr]

After opening the file in excel , high lit the range and reformat to display 2 decimal places. Or record the macro to select the range and perform the reformatting. something like this:

Note Macro is crude and generated by recording:



Sub Macro2()
'
' Macro2 Macro
' Macro recorded 10/4/2011
'

'
ActiveCell.Offset(1, 0).Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.NumberFormat = "$#,##0.00"
End Sub

 

[wigi]

Indeed the friend will need to reapply the formatting. Either manually, either with a macro. The macro could be stored in his/her personal macro workbook if wanted.