custom number formats

New Contributor

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

2 Replies
best response confirmed by Sergei Baklan (MVP)

@Christoph_Feichten Like this perhaps:

"month" 00;"month" -00





Thanks a lot!

 Oh my! so easy... completely forgot about this.