NumberFormat through Excel VBA

Question

I got to search and find similar issues on this, but not specifically on this

'Why this works:
Range("A2").NumberFormat = "[>999999]0,,\M;[>999]0,K;0"

'And not this:
Range("A2").NumberFormat = "[>999999999]0,,,B;[>999999]0,,\M;0"

What I am trying to accomplish is to have billions as "B" and millions as "M" (ideally all three with thousands as "K"). As always thanks for the help/explanations.

Try: [>=1000000000]#.##00,,," B";[>=1000000]#0.0,," M";#0.0," K" — JvdV
– JvdV, Commented Jul 8, 2020 at 12:41

bprijadi · Accepted Answer · 2020-07-08 12:54:04Z

1

Yes, thanks for the quick replies, I got it to work. Backslashes are mandatory not just for reserve "M" letter

Range("A2").NumberFormat = "[>=1000000000]0,,,\B;[>=1000000]0,,\M;0,\K"

Thanks Rory

answered Jul 8, 2020 at 12:54

bprijadi

254 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

NumberFormat through Excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related