Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number Format 1

Status
Not open for further replies.

jmcg

Technical User
Jun 30, 2000
223
GB
On my test site I use NumberFormat:
#NumberFormat(Evaluate(jmAnswer),"9")# and it shows fine on my test MX site.
When I upload to the live server which is 5.1 it only shows the first digit.
When I do not use NumberFormat it shows OK on the test and then puts one decimal place on the live system.

Any ideas to get round this. I want to show the number with no decimal places and no other formatting
 
Try more 9s?
#NumberFormat(Evaluate(jmAnswer),"999,999,999")#
 
Tried that and it forces the numbers into spaces before the digits start.
Ie
| 100 |
looks like
| 100 | with spaces in front of the number


 
What is in jmAnswer?

you can try #trim(numberFormat(evaluate(jmAnswer),"999,999,999"))#

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.
 
Trim worked a treat, still not sure what the problem was between the two versions but thanks for your efforts in sorting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top