Forum Discussion

Christoph_Feichten's avatar
Christoph_Feichten
Copper Contributor
Apr 03, 2022
Solved

custom number formats

When you format a cell, eg with "month" 00, you will see the text month 01, month 02 etc.   But if you want to have negative time periods before the point 0, you get - month 01, - month 02 etc. I ...
excel
Formulas and Functions
  • HumbertoPerezMX's avatar
    HumbertoPerezMX
    Copper Contributor
    Jun 26, 2023
    Hi riny, quick question, how did you know this, is there a document or cm where i can learn this, certainly on MS help, i could not find it

    thanks
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jun 27, 2023

      HumbertoPerezMX Search on-line for "Custom number formatting Excel" and you'll find many sites, blogs, tutorials. Quite much to read and it may take some time to find what you need, but it's all there somewhere. This is one of the first sites that come up for me:

      https://exceljet.net/articles/custom-number-formats 

       

      Then you also look at the custom formats already available in Excel. For instance, this one:

      _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

       

      Use it, see what happens, understand it and then change it a bit and see what happens. The internet resources can tell you about the meaning of ;_*@ etc. 

Resources