View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Getting rid of decimal numbers

the sheet is formatted to show only whole numbers.

--
Regards,
Tom Ogilvy


"copu2000" wrote in
message ...

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