Bill

Sometimes Excel can be stubborn, it's a sort of 'bug'. It's more prevalent
with imported data from other apps and we tend to get tons of questions on
here with VLOOKUPs and stuff that doesn't appear to work.

It is not possible in these cases to just re-format, so we give either the
copy blank - paste specialValues + Add or copy a 1, paste specialvalues +
multiply, both of which nudges Excel to 'behave'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Bill Martin -- (Remove NOSPAM from address)"
wrote in message ...
Nick Hodge wrote:

As Bill has pointed out, they may be text. Sometimes simply reformatting
may not do it.

Will it legitimately not reformat to numbers sometimes or are you talking
about a known bug?

Just curious...

Bill