Align left indicates text rather than numeric, try =Value(a1)



BaldySlaphead Wrote:
Addendum - when checking the original, non-functioning cells, there are
no trailing spaces appearing in the formula bar. In order to use the
new paste special values, as discussed above, I still need to click in
each cell so there is an active cursor. At that point, the numbers
align right (initially they appear align left) before they will pick up
for a chart.

Baldy


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=489748