Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Klarissa Schmidt   on Dec 23 In MS Office Category.

  
Question Answered By: Cleopatra Massri   on Dec 23

Can you go into detail on how this specific cell  is to be formatted? The
example you gave indicated

[>=10000000]#\,##\,##\,##0;

[>=100000]##\,##\,##0;

##,##0
As far as I can see the format  for 100 thousand to 10 million is the same as
the format for under 100 thousand. You can use a single format and rather
than a condition based format you can use the Positive;Negative;Zero;Text

Share: 

 

This Question has 12 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on combine number formats Or get search suggestion and latest updates.


Tagged: