View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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