Hello. Im trying to use Round function to round prices to end 900. I have 5 or 6 digit numbers without decimal ie ( 23450, 234500). When trying to use formula: =ROUND(AF2,0)-0.01 excel give me an error:

Not trying to type a formula?

When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:

• you type: =1+1, cell shows: 2

To get around this, type an apostrophe ( ' ) first:

• you type: '=1+1, cell shows: =1+1

I need help with this formula. Tried all options.

Thank you

Marko