wrap your expression with the num() function. Look it up in the help.
num( expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )
The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format set in the operating system is used.
for the second parameter - the format code - a tip I was given and which works is to go to the chart->properties->number dialgue and copy preferred format with cut and paste it into your num function. The format goes between simple quotes.
hope this helps.
Thank you very much.
Could someone PLEASE HELP ME report the following. Except for what I say below, I cannot send an email to Jason Long, whenever I click send it just tells me to enter the name of the recipient, which it then just ignores again. Please someone forward this to Jason Long or support or anyone who can help me, I cannot do anything on this site!
Also, whenever I use brackets in a post to show a field with spaces, when I post it it changes the field name to a hyperlink of the discussion! crazy.
Please look into this or tell me what to do. I also cant mark answers as correct anymore, dont know if this is just due to the new site or what.