rounding and removing

[evetz]

Hello all,

I am probably overthinking this, but I can't seem to find an easy way to round to a specific number, then have that number truncate the zeros.

for example, if I enter 8,291,275.46 I would like the output to give me 8291. If I enter 2,985.23 I would like the output to be 3.

I tried =round (a2,-3) but end up with 8291000.

Any help would be greatly appreciated.

[wk9128]

Pls try this formula

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

[etaf]

use a custom format
#,##0,

that will change the display - BUT the underlying cell number will not change
unless thats what you want to happen

you could divid by 1000

[evetz]

This formula works, but I had to replace ceiling with round as ceiling rounded up the 1. Thank you.

[wk9128]

@evetz You're Welcome. Glad to help . Thank You for the feedback and rep.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.