SOLVED

custom number formats

%3CLINGO-SUB%20id%3D%22lingo-sub-3274668%22%20slang%3D%22de-DE%22%3Ecustom%20number%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3274668%22%20slang%3D%22de-DE%22%3E%3CP%3EWhen%20you%20format%20a%20cell%2C%20eg%20with%20%22month%22%2000%2C%20you%20will%20see%20the%20text%20month%2001%2C%20month%2002%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20you%20want%20to%20have%20negative%20time%20periods%20before%20the%20point%200%2C%20you%20get%20-%20month%2001%2C%20-%20month%2002%20etc.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20format%20this%20case%20to%20month%20-01%2C%20mont%20-2%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%20Christoph%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3274668%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3274670%22%20slang%3D%22en-US%22%3ERe%3A%20custom%20number%20formats%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3274670%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1351551%22%20target%3D%22_blank%22%3E%40Christoph_Feichten%3C%2FA%3E%26nbsp%3BLike%20this%20perhaps%3A%3C%2FP%3E%3CP%3E%22month%22%2000%3B%22month%22%20-00%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1648968479471.png%22%20style%3D%22width%3A%20490px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F360905i9F969CD6EE1F0D2F%2Fimage-dimensions%2F490x280%3Fv%3Dv2%22%20width%3D%22490%22%20height%3D%22280%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1648968479471.png%22%20alt%3D%22Riny_van_Eekelen_0-1648968479471.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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)
Solution

@Christoph_Feichten Like this perhaps:

"month" 00;"month" -00

Riny_van_Eekelen_0-1648968479471.png

 

@Riny_van_Eekelen 

 

Thanks a lot!

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