custom number formats

[Christoph_Feichten]

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 · Accepted solution]

@Christoph_Feichten Like this perhaps:

"month" 00;"month" -00

[#3]

@Riny_van_Eekelen 

Thanks a lot!

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