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