formatting dollar amounts with missing decimals

[Paintballlovr]

I have a field that is dollars and cents, but with no decimal. Is there an easy way to insert a decimal or can anyone suggest any formatting adjustments. I tried to get creative and concatenate everything to the left of the last two positions + "." + the last two positions and it almost worked. There was one record that failed and I'm glad it did or I might not have realized it wasn't working. An example is one of the records says 5467377, which is actually 54673.77. My concatenation attempt failed on capturing the left side of the amount:

 Left([sumofbank_amount],(InStr([sumofbank_amount],(Right([sumofbank_amount],2)))-1))

[JoeM]

Where exactly are you trying to display this?
In a Query? Form? Report?

What is the Data Type of the "sumofbank_amount" field in the underlying table?
Why not just format the field to show the two decimal places?
If you use Text functions on it, it could convert the value to Text, and then mathematical computations may not work properly on them.

[ranman256]

use Currency data type, or format.
it will provide the decimal, unless your actual # is an integer (cents with no decimal?)

[Paintballlovr]

I eventually need to match it to another table which also has a dollar amount. The field imported as field size double, format general number, decimal places auto.

[Paintballlovr]

currency turns 10000 into 10000.00, but I need it to be 100.00

[RayMilhon]

What about dividing it by 100 and then converting to currency.

[Paintballlovr]

That did the trick. Its funny how sometimes I try to come up with elaborate solutions and the fix comes down to basic math. Thanks to everyone for your help.