What is there about the field that stops it being interpreted as a numeric field?
Assuming that there is a reason for that the way forward may simply be to accept it as text, convert it to numeric using a calculated field, divide by 100 and save the result with 2 decimal places. The VAL function should also work for this.
OR, find out what makes Monarch think it is dealing with a text field and try to eliminate the parts of the model selection that make it text.
Hope this helps.
when i import into Monarch it is formatted as 8565 and then when I try to format with decimal points it comes out 8565.00 which is incorrect, I have also tried with Currency and this also comes out incorrect any ideas /b[/quote]