c# - Currency Format for CSV File -


i'm formatting currency local standard e.g.

format 20000 r 20 000,00 using standard c# double.tostring()

string amount = order.amount.tostring( "c", system.globalization.cultureinfo.createspecificculture( "en-za" ) ); 

this works pretty until data exported csv file produces funny characters one: r 20 000,00. if open same cvs file in plain text file looks good.

anyone know how can rid of ugly looking a?

thanks in advance!

edit

here's how csv file gets created:

return file( new system.text.utf8encoding().getbytes( csv ), "text/csv", "order_report.csv" ); 

i'm writing app using asp.net mvc , opening in excel opening regular csv file.


Comments

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -