Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom cell formats combination of numbers and text
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom cell formats combination of numbers and text
Format the cells as Text and type in the entire string
-- Gary''s Student - gsnu200759 "sfeng63" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom cell formats combination of numbers and text
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom format cell with text and numbers | Excel Discussion (Misc queries) | |||
How do i zero pad when using combination of text and numbers? | New Users to Excel | |||
custom text formats | Excel Discussion (Misc queries) | |||
Custom formats to round numbers such as 16,465,123 to 16,500,000 | Excel Discussion (Misc queries) | |||
Custom formats to round numbers such as 465,123 to 465,000 | Excel Worksheet Functions |