I'm trying to 'concatenate' (sorry, I dont know the correct terminology in FileMaker) a number of different fields into one field.
Works great except when dealing with numbers with decimal places...
0.45 shows as .45
1.90 shows as 1.9
Is it possible to 'concatenate' with the zero before the decimal and in the second decimal position?
Basically, I'm getting: 20 x .45x1.2m = 10.8m² - start at £42.7 when I want: 20 x 0.45x1.2m = 10.8m² - start at £42.70
Sorry, am rather new to FileMaker, but any assistance would be appreciated!