Adding Decimals to a Field

[Jmacnevin]

Hello,

I'm using a data set that contains a field for dollar values, however there are no decimal spaces.  For example:

AMT

1050

896

469

I want to modify those fields to the following by adding a decimal;
AMT

10.50

8.96

4.69.

Can someone assist with a formula (assuming I would use the formula tool) to solve this issue?

Thanks!

[lwolfie · Accepted solution]

Could you use the formula tool and just divide by 100?  [AMT]/100 with the data type set to double.

[Jmacnevin]

Yes, that did work.  Thanks!