[ARO-RS3]

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!

[Advertisements]

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

[RKinner]

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

[ARO-RS3]

Thanks Ron, that worked!