Trucating The Integer

90 pts.
Tags:
Integer
truncate
In Excel, does anyone know how to truncate the interger portion of a number and just leave the decimal portion of a number?  For example, if I had a number: 965.678, what function in Excel would I use to "shave off" the 965 and just leave the .678?

Software/Hardware used:
Excel 2003

Answer Wiki

Thanks. We'll let you know when a new response is added.

Why not use the INT function instead of the TRUNC function.

The INT function is perfect for this as it is meant to return the integer of a number, (and it is better for those following your code as it is easier to understand.)

=A1 – INT(A1) says exactly what you are trying to do.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Whabby
    Thank you, Carlosdl, you have been a great help.
    90 pointsBadges:
    report
  • AndreaF
    This link shows examples for setting up custom number formats in Excel - hope this helps. http://office.microsoft.com/en-us/excel/HP051995001033.aspx
    7,850 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following