tag:blogger.com,1999:blog-6554229332422482192.post674872027243906254..comments2009-04-12T20:15:31.949-07:00Projectwomanhttp://www.blogger.com/profile/18407289311564764370noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6554229332422482192.post-17184091101196788112009-04-12T19:04:00.000-07:002009-04-12T19:04:00.000-07:00format to use: <BR/>[&gt;1000000]$#.0,,&quot;m&quot;;[&gt;1000]$#,&quot;k&quot;;$#,##0<BR/><BR/>for details or explanation refer to the website below:<BR/>http://excel.tips.net/Pages/T003528_Notation_for_Thousands_and_Millions.htmlAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6554229332422482192.post-69980968231034631682009-04-08T02:52:00.000-07:002009-04-08T02:52:00.000-07:00is there a way to combine both formula into one, so that various figures can just use one formula?<BR/>ie 1,000,000 as 1M; 100,000 as 100KAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6554229332422482192.post-71764558510777190432009-03-09T09:31:00.000-07:002009-03-09T09:31:00.000-07:00Just drop one of the commas for Thousands.<BR/><BR/>#,"k" for 20,000 to become 20k.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6554229332422482192.post-3508607748873037662009-02-10T08:25:00.000-08:002009-02-10T08:25:00.000-08:00Would this work for 1000's eg 20k?John CAulfieldhttp://www.mousetraining.co.uknoreply@blogger.comtag:blogger.com,1999:blog-6554229332422482192.post-27696322464945096412009-02-10T08:23:00.000-08:002009-02-10T08:23:00.000-08:00Perfect for millions does it work the same way for thousands eg 20Kjohn caulfieldhttp://www.mousetraining.co.uknoreply@blogger.com