Custom # formats

K

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.
 
N

Norman Harker

Hi Keyur!

Try:
Custom format:
"MS"# ##

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top