Changing the format doesn't change the value. But it does prepare it for the
next change (and F2|Enter is enough).

I like this technique:
Select an empty cell
edit|copy
select the range of offending cells
edit|paste special|check add

Excel will coerce the text numbers to number numbers.



BaldySlaphead wrote:

Bryan Hessey Wrote:
Align left indicates text rather than numeric, try =Value(a1)

That works, Bryan. But how come, even when I previously had changed the
format to numeric, it wouldn't work?

Many thanks for your assistance!

Baldy

--
BaldySlaphead
------------------------------------------------------------------------
BaldySlaphead's Profile: http://www.excelforum.com/member.php...fo&userid=1260
View this thread: http://www.excelforum.com/showthread...hreadid=489748

--

Dave Peterson