If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel rounds data when I open .csv files
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Excel rounds data when I open .csv files
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 |
#4
|
|||
|
|||
Excel rounds data when I open .csv files
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 "?????" wrote in message ... | 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 | |
#5
|
|||
|
|||
Excel rounds data when I open .csv files
It's very important for me 52.2 or 52.2000. The renaming file operation is
too long . There are different styles in Excel where one can choose the type for Numbers (General or Text or another one). May be do you know? How can I create default style for all documents? "Niek Otten" пишет: 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 "?????" wrote in message ... | 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 | |
Thread Tools | |
Display Modes | |
|
|