Integer and Decimal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarkC - 25 Mar 2007 21:26 GMT

Hello:

Using Excel 2002 (XP)

I know how to remove the Integer of 14.67 and end up with .67. But how can
one remove the decimal portion and leave the existing Integer 14?

Thanks,

Mark

Reply to this Message

JE McGimpsey - 25 Mar 2007 21:46 GMT

One way:

=INT(14.67)

> Hello:
>
[quoted text clipped - 6 lines]
>
> Mark

Reply to this Message

MarkC - 25 Mar 2007 23:09 GMT

Thanks JE!!!
MC

> One way:
>
[quoted text clipped - 11 lines]
>>
>> Mark

Reply to this Message