sfeng63,

Try this as your custom cell format:

"LMK-"@

HTH,

Conan



"sfeng63" wrote in message
...
I tried to find solution from MS Excel Help but was not success. I hope
you
can give me a help.
I am trying to setup a spreadsheet at work to record our meeting location,
such as LMK-597A or LMK-910. When I set up the format of the cell to
"LMK-"0000. It works if the room has number only but it does not work if
there is a letter. It will only give me 597A.
What should I change on the format in order to allow me to input the
letter.
Thanks for your help in advance.