Money fields

[The Mad Jammer]

I imported a text field that I want displayed as a money field. However, instead of displying the correct amount the program displays 2 zeros to the right of the decimal point instead of placing the decimal point two digits from the end of the text (i.e. 13155 shows up as $13,155.00 instead of $131.55). How do I fix this?

Thanks

The Mad Jammer

And then...there was nothing

[ernst]

Hi Jammer,

If you have to do this import often then I would suggest playing with the settings of your 'numbers' control panel (MacOS 9), 'international' system preferences (MacOS X) or the windows equivalent of those.

You can also just replace your found set with YourField/100...

Regards,

Ernst.

[Lee Smith]

Hi

This seems to work.

Substitute(TextToNum(YourTextField), Right(TextToNum(YourTextField), 2), ".") &

Right(TextToNum(YourTextField) , 2)

Note: subsitute your own text field for "YourTextField" in this calculation. The result of the calculation is number and then you need to format your number as dollars on the layout.

If you want to keep it as a text field, than this sould do it for you

"$" & Substitute(YourTextField, Right(YourTextField, 2), ".") &

Right(YourTextField , 2)

Lee

[The Mad Jammer]

Thanks for your help.

[Lee Smith]

U R Welcome