• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

to bring abbreviation B for billion and T for trillion.

A

abdulncr

Member
Hi friends,


I have number trillion and million in a column and make it to the chart. the follow code pasted in the format cell custom- working fine for million and billion. Please help me how do i get it work for trillion too.


[>999999999.999]#.0,,, _-"B";[>999999.999]#.0,, "M";#,##0 _M


Regards

Abdul
 
You have already posted this question


http://chandoo.org/forums/topic/million-and-trillion-short-form-in-cell


Double posting is bad manners and an insult to those who have tryed to help you in your previous post
 
You must log in or register to reply here.
Back
Top