| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping excel from performing subtraction so text remains as is
I am creating a spreadsheet to track football scores, i.e.
W-L 23-14 37-12 Is there a way to keep excel from performing the subtraction function in these cells so the text will appear as I've typed it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping excel from performing subtraction so text remains as is
Hi,
Format the cells as text before you enter your data Mike "jrambo" wrote: I am creating a spreadsheet to track football scores, i.e. W-L 23-14 37-12 Is there a way to keep excel from performing the subtraction function in these cells so the text will appear as I've typed it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Keeping excel from performing subtraction so text remains as i
Thanks!
"Mike H" wrote: Hi, Format the cells as text before you enter your data Mike "jrambo" wrote: I am creating a spreadsheet to track football scores, i.e. W-L 23-14 37-12 Is there a way to keep excel from performing the subtraction function in these cells so the text will appear as I've typed it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding text and performing a calculation | Excel Worksheet Functions | |||
| keeping an auto shape or text box visible in an excel chart | Charts and Charting in Excel | |||
| Keeping lead zeros in excel text format when saving as CSV file | Excel Worksheet Functions | |||
| Performing arithmetic functions to cells with number and text | Excel Discussion (Misc queries) | |||
| numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) | |||
Linear Mode
