Thanks Richard,

I finally worked out how to fix the complete column in one hit, but my Qs
still are,

1. why does the cell format show the cell is formatted as number when it's
not!

and,

2. why didn't the format painter work?

Rob

"RichardSchollar" wrote in message
oups.com...
Hi Rob

You may be able to convert an entire column in one go by selecting it
(the whole column) and going DataTextToColumns and click Finish.

Hope this helps!

Richard



On 14 Mar, 05:24, "Rob" <none wrote:
Hi,

I have pasted some data into a spreadsheet from another accounting
application (MYOB) and have trouble having Excel see the amounts as
numbers.
It seems that even if the cells are formatted as a Numbers or Currency,
etc., a simple formula like =SUM(G7:G13) does not see them as numbers.

They all have a small green triangle in top left of cell, and when I
select
a cell and select the option "Convert to Number" it will only then be
seen
as a number.

If I then try to use the format painter to format all the other cells
like
it, the format painter does nothing.

Can someone please tell me what's going on here and a solution, if any,
as
the workbook will be used often to import new data.