custom number format with text

[tomas]

Hi

A need to add text to number based on its value. How I need it, it's shown in range A1:B5. Text though contains characters special to my language but use whatever I can change the text when otherwise its ok . Cell with values are grayed a that is where I would like to apply the custom format

thanks in advance

 

[Khalid NGO]

Hi Tomas,

See if this is okay.
I have used some CF.

Regards,

 

[tomas]

Hi Khalid

Works as needed

thanks

 

[Khalid NGO]

Hi Khalid

Works as needed

thanks

Glad it worked.
and you are welcome Tomas.