That is no information loss; 52.2 as a number means the same as 52.2000000
However, if you want to treat the item as text, rename the file a .txt file; you'll get the import wizard on opening the file and
you can choose the "number" to be text
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| 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
| > >