How to delete digits after period

R

Rogermb

I am working on a price list and want to delete the multiple digit
after the period and permanmently on keep two. I know about th
increase and decrease decimal. But I need to permanently delete th
digits. Can anyone help
 
B

BenjieLop

Rogermb said:
I am working on a price list and want to delete the multiple digit
after the period and permanmently on keep two. I know about th
increase and decrease decimal. But I need to permanently delete th
digits. Can anyone help?

=INT(A1

will return the whole number of your price. Copy this formula down a
required
 
Top