Custom Formatting

[Iknewthisguy]

I have a central point of Mo. 0 which is easy enough to format that way so it is still recognized as a number. Any ideas how to format the cells so that I can get "Mo. -1" or "Mo. 2" on either side of "Mo. 0"?

Any help would be appreciated.

Chris.

 

[shg]

Wouldn't it be flanked by Mo. -1 and Mo 1?

Use the same format, and put -1 and +1 in those cells.

 

[Iknewthisguy]

The "-1" ends up showing "-Mo. 1".

 

[shg]

Format as "Mo. "0;"Mo. "-0;"Mo. 0"