Easy one - but I can't get it!

[alphanitrate]

I import an excel file to gain pricing info etc.

Currently I have Round(field):1 this take all the weights and rounds them up to a single decimal place. Works great.

10.37 = 10.4

The issue i have is if the weight comes in as 10 only i need to put in a zero at the end.

Any thoughts?

[mr_vodka]

Format the field ( format as number ) with 1 decimal place.

[alphanitrate]

mr_vodka

sounds straight forward enough... uhm how?

[The Big Bear]

in the layout mode

in menu goto format

choose numbers

choose format with decimel and chose one space

hope this helps

[alphanitrate]

ok found it thanks, is there a way just to do the one field? I have 16 other number fields that do not require the decimal.

[mr_vodka]

Select the field that you want first then go to the Format menu.

[alphanitrate]

You guys are awesome! thanks for replying to me on this simple topic!