LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Excel 2003/2007 paste special values shows bizarre results

When I subtract a set of numbers, then take the result and paste special -
values, often my results show a bizarre number of decimal places.

The cell shows the correct value, but the formula bar shows the oddball
numbers.
(Apparently it is using the imsub function to grab the value instead of the
sub function.) This is causing havoc with a few comparison calculations I am
trying to do within the worksheet.

Any suggestions on how to fix this?



 
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
What happened to paste special in Excel 2007? Louis Excel Discussion (Misc queries) 6 March 6th 08 07:59 AM
paste special as text to excel 2007 ( sp1 updated) exlover Excel Discussion (Misc queries) 0 February 7th 08 05:15 PM
Paste Special Help (Excel 2003) Newbeetle Excel Discussion (Misc queries) 5 January 31st 08 09:17 PM
Paste Special in Excel 2007 Gren Excel Discussion (Misc queries) 0 January 15th 08 04:52 PM
Paste Special, Text in Excel 2007 Vernon Balbert New Users to Excel 13 November 4th 07 07:18 PM


All times are GMT +1. The time now is 02:53 AM.

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"