Apr 02 2022 11:38 PM
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
Apr 02 2022 11:48 PM
SolutionApr 03 2022 10:56 PM
Jun 26 2023 04:02 PM
Jun 26 2023 09:33 PM
@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.
Apr 02 2022 11:48 PM
Solution