Removing pennies

  • Thread starter Thread starter Jody
  • Start date Start date
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!
 
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
 
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
 
-----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
 
Back
Top