Zero - problem

**Haerens** · 07-06-2011, 07:26 AM

Dear to all,

In the attachment I have put an excell file ... I have to delete each time all the 0's manually ... now is there a possibility to delete the "0" automatically?

Note the green triangles on the upper left of each cell.

Thank you !

Best regards,

Haerens

**Roger Govier** · 07-06-2011, 07:33 AM

Hi

Tools>Options>General>uncheck the Zero Values box

If you want to get rid of the Green Triangles
Tools>Options>Error Checking>uncheck Enable background error checking

**zbor** · 07-06-2011, 07:37 AM

You have green triangles because your numbers (0) are stored as text.
To solve this problem click on cell with a green triangle (a yellow box with ! should appear).
Select all
Find that box and choose: Convert text to numbers.

To solve problem with no showing zero go to Excel options -> Advanced
And uncheck box under Display options for this woksheet -> Show a zero in cells that have zero value