Showing decimals only

[Triple]

Hello,

This is probably very simple, but I can't figure it out for the life of me. I am trying to make a 3 digit decimal which is less than 1 appear without the 0 to the left of the decimal point. i.e. I have an average that I want to appear as .420 and not 0.420.

Any Suggestions?

Thanks

[RalphL]

You will have to change the average to text. One way to do this is:

"." & GetAsText (Round (1000 * Your Average ; 0))

this will insure trailing zeros.

[mr_vodka]

Please do not double post.

http://fmforums.com/forum/showtopic.php?tid/201023/post/318170

[Triple]

This worked perfectly! Thanks for the help.