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?

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

mr_vodka

sounds straight forward enough... uhm how?

in the layout mode

in menu goto format

choose numbers

choose format with decimel and chose one space

hope this helps

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.

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

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