Excel rounds data when I open .csv files
Thank you for answer,
The fact is that information is lost. I don't know what value file contained
(52.2000 or 52.200 or 52.20000000 .... ). I see only 52.2. Therefore I don't
know how many numbers should be shown :(
"john" пишет:
You need to change the number of decimals to be shown in a cell in the cell
formatting or using the increase decimal on the toolbar
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get
Ice Hockey rules (especially the Wightlink Raiders)
"Антон" wrote:
Hi, All
Please help me! I have such problem: I have .csv files with not-rounded
numbers (for example 50.20000, 100.00000). When I open the file Excel rounds
the not-rounded numbers (50.2 and 100 accordingly). Could you please tell me
how can I open .csv files without 'autorounding'.
Thanks in advance
|