Delete numbers

R

Rogermb

I need to import a price list from Excel to SAP. The problem is that
need to import a price with only two digits after the period lik
63.45. The problem is I was sent a price list with many digits lik
63.4578932 or 12.3268246987. I would like to permanently delete the
digits forward and just keep the two digits after the period as i
63.45 or 12.32. I know about the increase and decrease decimal. But
need to permanently delete the digits. Can anyone help?

Thank you

Roge
 
J

JK

You can use the TRUNC or ROUND commands to get your price value to 2 digits
after the decimal. If SAP still shows more than 2 digits, then copy the
column in Excel that shows only the 2 digits after decimal and do a paste
special with values only.

Don Guillett said:
Have a look in HELP index for INT
Click to expand...
 
Top