Forum Discussion

Christoph_Feichten's avatar
Christoph_Feichten
Copper Contributor
Apr 03, 2022

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 would like to format this case to month -01, mont -2 etc.

 

How can I do this?

 

Regards, Christoph

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. 

Share

Resources