Custom # formats

[Keyur]

hi

i a column where my number format is 'MS# ##' how can i
make a custom format so that if i enter, say 106, then it
should turn it into 'MS1 06'?

thanks for any help.

 

[Norman Harker]

Hi Keyur!

Try:
Custom format:
"MS"# ##

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.