Excel in Office 365, CSV file problems

Excel 365 seem to have a problem when saving from Excel to .CVS

Decimal places for numbers are lost despite the numbers being formatted as number with 4 decimal places before saving as a CSV file. So technically the numbers, with the 4 decimal places should appear when imported using the data import function in Excl.

But the decmail places are lost. 

It seems s if there is a problem with Excel recognising the . as the decimal separator, even though I use USA(English) as the regional setting with the . set as the decimal separator

Category: Microsoft Excel 4 weeks ago
Microsoft Office
Asked 4 weeks ago

Like it on Facebook, Tweet it or share this question on other bookmarking websites.


This question is not yet answered.
Attachments