LinkBack URL
About LinkBacks
laglenn 
I know there's a way, but can't remember:
How can I format a number (e.g. $1,450,000) to display without the last three digits (e.g. $1,450)?
Thanks!
I know there's a way, but can't remember:
How can I format a number (e.g. $1,450,000) to display without the last three digits (e.g. $1,450)?
Thanks!
Use a trailing comma in the format string, e.g.,
_($* #,##0,_);_($* (#,##0,);_($* "-"??_);_(@_)
Entia non sunt multiplicanda sine necessitate
excellent - thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks