How to delete digits after period

[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

 

[Frank Kabel]

Hi
=ROUND(A1,0)

 

[BenjieLop]

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

 

[Myrna Larson]

If you mean you want to retain 2 digits, =ROUND(A1,2)

 

[Rogermb]

thank you very much......