Number Format

[JennJenn]

I calculated a number in a field and I am trying to get the number to format as such:
If the calculated answer is 25, I would like it to format as 25.00 instead of 25

It is calculating as an integer and I do not want it to do that. Also, my table is formatted as a text field and I must keep it this way, so how can I work around this. When I use Val, If I multiply 25.345 * 1, it gives me 25.345. I would like it to give me 25.35 as the answer.


Thanks

 

[Rich]

Why must you keep it this way?

 

[JennJenn]

This application interfaces with another and in order for the spacing, etc. to sync correctly with the other system, this is the way it had to be designed.

I figured it out. I formatted the code with Format(expression, "###0.00")

Thanks

[This message has been edited by JennJenn (edited 06-03-2002).]