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.