Excel 2003 Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry


This is a pretty interesting problem with Excel that I have never seen
before and has frustrated me to no end. Any input or suggestions would
be greatly appreciated.

All I am trying to do take to values from two columns (A and B) and add
them together into a third (C). The formula is correct, but the end
result is zero, as if it does not recognize the data as numerical.
Attempting to change the format does nothing, I cannot add dollar
signs, or decimal points to the numbers, and I've even opened a new
spread***, pre-formatted the columns to be numbers, and used 'paste
special-values' and there is no change. If I retype the number in the
cell (A or B), it recognizes the new data as a number, and cell C is
adjusted accordingly.

Any help you can offer would be awesome because if I don't figure this
out, I will have to retype hundreds of rows.

Thanks


--
ChrisR9040
------------------------------------------------------------------------
ChrisR9040's Profile: http://forums.techarena.in/member.php?userid=16613
View this thread: http://forums.techarena.in/showthread.php?t=560775

www.techarena.in

.

Quantcast