You can apply a custom format to the cells E6:E16, of

"NM "0

which will give you an appearance of NM 1, NM 2 etc. with your existing formula.

Hope this helps.

Pete