Format Cell

[HESH]

Hello friends
i use this custom format cells
[>=100]"High "0;[<-50]"Low "0;"Average "0
and it is ok
the problem when i have any minus number from -1 to -49, Excel add - to word Average
like this


2 = Average 2
222 = High 222
-3 = -Average 3
-55 = Low 55


how i can remove this minus

 

[HESH]

Any Idea for this

 

[HESH]

Up please

 

[bjbalmforth]

Try the find and replace function, record a macro of the steps and place a button on your sheeet.