LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
sky2surf
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling Source Data Array with Decimal Values John Michl Charts and Charting in Excel 6 March 22nd 06 04:17 PM
Aligning Decimal Points with non-numeric data notloiseweiss Excel Discussion (Misc queries) 3 November 11th 05 10:17 PM
Charts not recognizing source data if original linked data is changed. JLC Charts and Charting in Excel 3 October 14th 05 01:29 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 03:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"