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

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