Rounding to the nearest hundred

G

Guest

I am looking for away to have currency values rounded to the nearest
hundreds. For example $25,762.14 would round up to $25,800.00 and $14,243.00
would round down to $14,200.00.

Any help would be appreciated.

Thanks, Bob
 
G

Guest

Thanks, it worked.

Ofer said:
Try this

format(format([MyNumber]/100,"#")*100,"#,###.00")

Bob said:
I am looking for away to have currency values rounded to the nearest
hundreds. For example $25,762.14 would round up to $25,800.00 and $14,243.00
would round down to $14,200.00.

Any help would be appreciated.

Thanks, Bob
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007: % fields rounding to nearest integer 3
Preventing rounding numbers to nearest dollar 2
Rounding to the nearest hundred in Access 1
Rounding up to the nearest .25 1
Rounding to the nearest cent...currency values 3
Microsoft Access 2000 2
Rounding to a given precision 2
Rounding to the nearest 0.25 4

Top