Exporting Excel from PHP and getting 'Green Arrows'

[wood1e2]

Hi,

I have just set up a php export into.xlsx and when I download and open there is nothing wrong, as does when my client, but when they open, little 'green triangles' appear, like when there 'sum' in one cell is different to the 'sum' in the cells immediately to the left (or right) of the first cell.

is there any way of getting rid of these?

 

[wood1e2]

Hi

Sorry, I think I have found out why this occurring.

Within several cells, there is £ and data, so for example: £10,000

If I follow the sets to remove 'Error Checking' within Options within Excel, everything is fine.

But is there a way of telling Excel that this is an acceptable rule? or stop the Green Triangles appearing when there is no issue!!