Custom cell formats combination of numbers and text

  • Thread starter Thread starter sfeng63
  • Start date Start date
S

sfeng63

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.
 
Back
Top