rounding

BRM108

New Member
Joined
Aug 2, 2010
Messages
4
Good Morning,
I would like some help with a function that can round a number such as $2,064,584 to $2,065.
Thanks.
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

prabby25101981

Active Member
Joined
Jul 28, 2010
Messages
348
How many digits do you want in the final number? If you want 4 digits, then here's the formula -

=ROUND(A13/LEFT(CONCATENATE(1,"0000000"),4),0)

Format it in currency...
 
Last edited:

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
Perhaps:
=ROUND(A1,-3)/1000

Alternatively, you could go change the number format to custom and enter:
$0,000,

though the underlying number would still have all of the digits, it would just display as desired.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,950
Messages
5,508,327
Members
408,679
Latest member
Daven13

This Week's Hot Topics

Top