| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want to type a text in a cell, but I want that text to represen.
I want to type text into a cell (actually the checkmark symbol in winding2)
but I want that text to represent a number. So if I have 3 cells each with the checkmark and each of those cells represents the number 1 when I auto sum I will get a total of 3. |
|
#2
|
|||
|
|||
|
If they represent 1 you can just count them with countif
=COUNTIF(Range,"character") regards, Peo Sjoblom "ExcelQ" wrote: I want to type text into a cell (actually the checkmark symbol in winding2) but I want that text to represent a number. So if I have 3 cells each with the checkmark and each of those cells represents the number 1 when I auto sum I will get a total of 3. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Text in cell not showing in full | Excel Discussion (Misc queries) | |||
| Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
Linear Mode
