LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Getting rid of decimal numbers


What can cause non-integers becoming integers when copying them from one
Excel workbook to another ?

Even if one do the decimal spaces reduction and it appears as integers
but when it was pasted to another workbook, one can still see the
decimal numbers in the function box when one click on those newly
pasted integers.

I know that you will have to do a manual round up/down functions on the
non-integers but barring these from being use, what could be the other
reasons.


--
copu2000
------------------------------------------------------------------------
copu2000's Profile: http://www.excelforum.com/member.php...o&userid=31112
View this thread: http://www.excelforum.com/showthread...hreadid=507789

 
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
Decimal Numbers typed into Excel 2003 read as whole numbers john mcmichael Excel Discussion (Misc queries) 1 May 10th 07 08:18 PM
Subtracting two 2-decimal place numbers gives result 13-decimal places? [email protected] Excel Worksheet Functions 5 March 12th 07 10:38 PM
How can I sort mostly 3 decimal with some 4 decimal numbers PeterM Excel Discussion (Misc queries) 4 August 16th 06 02:15 AM
Too Many Numbers After The Decimal RChicken Excel Discussion (Misc queries) 4 July 5th 06 04:39 PM
Decimal numbers not recognized as numbers Stein Kristiansen[_2_] Excel Programming 3 February 13th 05 09:54 PM


All times are GMT +1. The time now is 05:44 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"