Custom Format

[Paella1]

Is it possible to set a cutom format that will display the value -1 as CY-1, rather than as -CY1 ?

 

[RonB1111]

Try this in custom number format:
0;"CY-"0

 

[mikerickson]

If you want -1 to appear as CY-1 and -2 to appear as -2, you could use this custom format
[=-1]"CY-1";General

But from your OP, I wonder if you want 1 to appear as CY1 and -1 to appear as CY-1 you could use
"CY"0;"CY-"0

 

[Paella1]

Both spot on. Thanks guys.

I failed to mention that I want the CY before the positive numbers too, so good pick up, Mike.