| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Custom Format
I want to format a cell in Excel to always have the word "Tuition-" then
whatever I type in. I could get it to work if I type in numbers, but not alpha. I formatted the cells to be "Tuition-"? Any suggestions? |
|
#2
|
|||
|
|||
|
I think you'd be better off creating a separate column. In A, type what you
want. In B, use the formula ="Tuition-"&A1. You can always hide A if you don't want it. Or, you can highlight B, copy, paste special values, and delete column A. Hope this helps. Jane "MistyR" wrote: I want to format a cell in Excel to always have the word "Tuition-" then whatever I type in. I could get it to work if I type in numbers, but not alpha. I formatted the cells to be "Tuition-"? Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Custom Toolbars in Excel 2003 | Setting up and Configuration of Excel | |||
| How do I put Excel data into a US map format? | Charts and Charting in Excel | |||
| convert .123 format to Excel? | Excel Discussion (Misc queries) | |||
| How do I change Excel format to pdf format? | Excel Discussion (Misc queries) | |||
| Custom Format and Data Validation Q | Excel Worksheet Functions | |||
Linear Mode
