Removing pennies

J

Jody

I need to remove the pennies from the numbers in a column.
I know I can format the cells so the decimal places do not
show but I need to actually remove the cents so all
numbers show in whole dollars. Help!
 
F

Frank Kabel

Jody said:
I need to remove the pennies from the numbers in a column.
I know I can format the cells so the decimal places do not
show but I need to actually remove the cents so all
numbers show in whole dollars. Help!
Click to expand...

Hi Jody
try
=ROUND(A1,0)
where A1 stores your dollar value (this will round your dollar amount).
If you just want to remove the decimals try
=TRUNC(A1,0)

Frank
 
N

Niek Otten

In Financial spreadsheets, it is often a good idea to

Tools>Options>Calculation, check "Precision as displayed"

Read Help for details.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
G

Guest

-----Original Message-----
I need to remove the pennies from the numbers in a column.
I know I can format the cells so the decimal places do not
show but I need to actually remove the cents so all
numbers show in whole dollars. Help!
.
I would suggest "format\cells" select currency...then set
Click to expand...
the number of decimal places to 0.
Al
 
Top