| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I keep excel from calculating text so it stands as is?
I am creating a worksheet that I want to list football scores, i.e.
W-L 23-6 41-23 Is there a way to keep excel from actually performing the subtraction function so when I type them this way they stay there? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I keep excel from calculating text so it stands as is?
format as text first or put ' in front
-- Don Guillett Microsoft MVP Excel SalesAid Software "jrambo" wrote in message ... I am creating a worksheet that I want to list football scores, i.e. W-L 23-6 41-23 Is there a way to keep excel from actually performing the subtraction function so when I type them this way they stay there? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I keep excel from calculating text so it stands as is?
Pref-format the cells to text and enter the values
OR Prefix your cell entry with an apostrophe '23-6 If this post helps click Yes --------------- Jacob Skaria "jrambo" wrote: I am creating a worksheet that I want to list football scores, i.e. W-L 23-6 41-23 Is there a way to keep excel from actually performing the subtraction function so when I type them this way they stay there? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I keep excel from calculating text so it stands as is?
Thanks so much!
"Jacob Skaria" wrote: Pref-format the cells to text and enter the values OR Prefix your cell entry with an apostrophe '23-6 If this post helps click Yes --------------- Jacob Skaria "jrambo" wrote: I am creating a worksheet that I want to list football scores, i.e. W-L 23-6 41-23 Is there a way to keep excel from actually performing the subtraction function so when I type them this way they stay there? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I keep excel from calculating text so it stands as is?
You may want to use two cells.
Then you'll be able to do arithmetic pretty easily. jrambo wrote: I am creating a worksheet that I want to list football scores, i.e. W-L 23-6 41-23 Is there a way to keep excel from actually performing the subtraction function so when I type them this way they stay there? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change appearance of cell being used so it stands out | Excel Worksheet Functions | |||
| Change Text to number & Excel not calculating formula | Excel Discussion (Misc queries) | |||
| Calculating text in a column | Excel Discussion (Misc queries) | |||
| what does command simulation stands for,how to use? | Excel Worksheet Functions | |||
| Calculating cells with text only | Excel Worksheet Functions | |||
Linear Mode
