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: Patty Freeman   on Dec 23

The format  wanted is 12,34,56,789 which is in use in some countries (sorry,
I forget which). Hence the need for literal commas and ranged custom
formats.

Unfortunately, Excel ignores the number  of digits you put between
non-literal commas in a custom  format and assumes you wanted three, no
matter how many you actually had.

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: