Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some cells contain # and text, some # only - want to sum # (number
Say cell A1 contains 1*, and A2 contains 1, when I do sum(A1:A2) I get 1 as
the answer (obviously). I would like to be able to include the numerical part of the entries in these cells and ignore the text part. I know that I can format cell A1 like this: # "*", but to apply a special format to each cell that includes the * is a clumsy approach I think. Is there any way to format all the cells so that the *'s are ignored, without writing a macro? Thanks for your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Changes Text Cells to Number Cells When Importing XML | Excel Discussion (Misc queries) | |||
sumif where cells contain Number & Text | Excel Discussion (Misc queries) | |||
number of cells containing text | Excel Discussion (Misc queries) | |||
How to set a number number value as text in all cells ? | Excel Worksheet Functions | |||
total cells with text and number EX: GS-5 | Excel Worksheet Functions |