![]() |
Sergey Kornilov admin 1/30/2013 |
You will have to format it manually in this case. |
J
|
JohnLug author 2/6/2013 |
That link gives good examples, but not what I'm needing. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=69708&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> |
![]() |
Sergey Kornilov admin 2/6/2013 |
This is what you need to use, just remove the trailing zero after applying FormatNumber function. |
J
|
JohnLug author 2/6/2013 |
Sorry, but I'm missing something. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=69716&image=1&table=forumreplies' class='bbc_emoticon' alt=':o' /> |
![]() |
Sergey Kornilov admin 2/6/2013 |
Yes, it doesn't show that. You need to apply the FormatNumber function first, then check if resulting string has "0" at the end of it and remove it if required. |
J
|
JohnLug author 2/7/2013 |
Thanks to Sergey, this now works!! |