Numers/Text formatting

[Chris Wood]

I am having a formating problem.

I have two number fields (Num_1 and Num_2). These contain numbers with one decimal place.

They are number fields becasue they are used for sorting.

A third field (Num_3) is formatted as a calculation: NumToText (Num_1) & " / " & NumToText (Num_2)

With the result set to be text.

The result is fine until one of the numbers is, for example, 34.0

In the calculation field this appears as 34

What ever I seem to do I cannot get the calculation to return a decimal number when there is a zero after the decimal point.

Can anyone help please.

Chris

[slstrother]

Check the thread below, it will give you some ways to do what you want.

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB45&Number=34693&page=2&view=collapsed&sb=5&o=0&fpart=

[Chris Wood]

Thanks for pointing me in the right direction.

Chris