Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal value changed after pasting data
I copy report data (has multiple columns) from an emulation session (host explorer) and paste on Excel for calculation. It used to work beautifully. Somehow it doesn't seem to work anymore. For some numbers with one decimal, some of the decimal value got changed to zero (i.e. 53.1 to 53.0, 125.6 to 125.0 etc...). However, it does work for some other numbers within the same column. Any idea what could be the problem? I'm running Excel 2k sp3 on Win2k. Thanks! -- sky2surf ------------------------------------------------------------------------ sky2surf's Profile: http://www.excelforum.com/member.php...o&userid=33883 View this thread: http://www.excelforum.com/showthread...hreadid=536617 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal value changed after pasting data
There's no chance that the column width is just too narrow to show the decimal
portions of the values? (125.6 would have appeared as 127, though.) If you're copying from a Host Explorer session (just selecting and edit|copy), maybe you could paste into Notepad to test to see what you're actually picking up??? sky2surf wrote: I copy report data (has multiple columns) from an emulation session (host explorer) and paste on Excel for calculation. It used to work beautifully. Somehow it doesn't seem to work anymore. For some numbers with one decimal, some of the decimal value got changed to zero (i.e. 53.1 to 53.0, 125.6 to 125.0 etc...). However, it does work for some other numbers within the same column. Any idea what could be the problem? I'm running Excel 2k sp3 on Win2k. Thanks! -- sky2surf ------------------------------------------------------------------------ sky2surf's Profile: http://www.excelforum.com/member.php...o&userid=33883 View this thread: http://www.excelforum.com/showthread...hreadid=536617 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal value changed after pasting data
Column width is not too narrow and it pastes on Notepad & Word fine. However, just strangely converted some, but not all, decimal portion when paste in Excel. Unfortunately, Notepad & Word seem to lose the column identity such that when I tried to recopy from Notepad or Word to Excel, the data resulted in a single column. Any other thoughts? -- sky2surf ------------------------------------------------------------------------ sky2surf's Profile: http://www.excelforum.com/member.php...o&userid=33883 View this thread: http://www.excelforum.com/showthread...hreadid=536617 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling Source Data Array with Decimal Values | Charts and Charting in Excel | |||
Aligning Decimal Points with non-numeric data | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |