SOLVED

custom number formats

Copper 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

4 Replies
best response confirmed by VI_Migration (Silver Contributor)
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.  

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

@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. 

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Christoph_Feichten Like this perhaps:

"month" 00;"month" -00

Riny_van_Eekelen_0-1648968479471.png

 

View solution in original post