Combining custom cell formats

[AndyGW]

I know you can make excel put + before all positive numbers and remove zeroes before decimal spaces using custom cell formatting, but can you do both?

eg make 0.5 look like +.5 or make 0.5 look like +½

[MarvinP]

Hey Andy,

Is this what you are looking for?

https://support.office.com/en-us/art...3-7db51fd83b77

[shg]

make 0.5 look like +.5

Format as +#.0;-#.0

[AndyGW]

Perhaps. Once I've read through it. I can make something display as a fraction and I can make excel add +'s before all positive numbers. I can't do both though. I guess my original question is better put as; can you combine multiple differing custom cell formats?

[AndyGW]

Thanks, Shg. Can you give me the custom format for +'s and fractions?

[AlKey]

IF you want it with fraction
Format as +#?/?

[MrShorty]

Back when I was first learning Excel, this was one of my most referred to help files: https://support.office.com/en-us/art...2-09fab54be7f4 with all of the different number format codes, what they do, and how to use and combine them.

[AndyGW]

Thanks, AlKey and MrSHorty. I've often wondered how anybody made sense of the cell format code, this will help alot.