Excel 2002 - dropping decimals (no rounding) - Geeks to Go Forums

Jump to content

Log in Register Register Malware removal guide How it works

Excel 2002 - dropping decimals (no rounding)

#1 ARO-RS3

  • Group: Member
  • Posts: 6
  • Joined: 14-August 12

Posted 14 August 2012 - 04:41 PM

I have a spreadsheet with monetary values and I don't want them to round up or down, I want to drop at the 100th decimal. i.e. I want $0.77777 to automatically convert to $0.77, currently it is rounding it to $0.78.

Thanks!

#2 RKinner

  • Group: Expert
  • Posts: 10,637
  • Joined: 19-April 05

Posted 14 August 2012 - 10:42 PM

In Office Office you can do it with:
TRUNC(Number; Count) I assume you can do the same in Excel.

TRUNC(.777777;2) = .77

or create a second column and have it do the trunc of cells in the first column and then hide the first column.

Ron

#3 ARO-RS3

  • Group: Member
  • Posts: 6
  • Joined: 14-August 12

Posted 15 August 2012 - 08:26 AM

Thanks Ron, that worked!

Share this topic:


Page 1 of 1