ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel postfix number format (https://www.excelbanter.com/excel-discussion-misc-queries/54416-excel-postfix-number-format.html)

s05ullivan

excel postfix number format
 
Add builtin number formatting for automatic postfix letters such as T, G, B,
M, K typical for metric units or dollar figures ($B, $M, $K). Automatically
switch between letters given number size ($3,200M becomes $3.2M). This
aspect overcomes the limitation of the current number formatting approach.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com