Sum of Numbers appear as zero- Please help

  • Thread starter Thread starter Tina C.
  • Start date Start date
T

Tina C.

Please help!

I have a spreadsheet that adds up sales projects for each
of our territories into a total company. When I went back
to verify the calculations, I realized that zeros were
appearing in some of the calculations. It appears that
the column format was set to text. I've tried to change
it to general or number but nothing works unless I retype
everything. Is there something else I can do?

Example:
Group 1: =sum(A1:A2)=0 [Should be 700]
Product 1: 200
Product 2: 500

Any ideas would be greatly appreciated.

Tina
 
Hi Tina -

Put the number 1 in a blank cell (that is formatted as
general). Copy that cell. Select all the cells that
should be formatted as general. Choose, Edit, Paste
Special, Multiply. This should fix the problem!
 
Not sure about your situation, but often this works:

Format an empty cell as General. Enter the number 1. Edit>Copy. Select the
cells formatted as text. Edit>Paste special, check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top