Newbie problem: numbers with +positive and -negative indicators
Seems like you've got text the needs to be made numeric. Select a blank cell
(or put a 0 in some random cell and select it). Then ctrl+c to copy it.
Select your range of cells that need to be converted, right-click and select
paste special. Choose Values and Add, then click ok.
".Net Sports" wrote:
I have a column of numbers that i need to have a positive or negative
indicator to add up with the AutoSum function,
+3
-3.5
+10
....but can't get the autosum function on the row below to
calculate...i get an empty " =sum( ) " display; what is the correct
way to format these numbers so i can get the total of +9.5 with this
column
|