ExcelBanter - on exel how do I can take out the ceros on the woksheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - on exel how do I can take out the ceros on the woksheet? (https://www.excelbanter.com/excel-worksheet-functions/27632-exel-how-do-i-can-take-out-ceros-woksheet.html)

ana ibarra

on exel how do I can take out the ceros on the woksheet?

hi, please help me
I am doing a worksheet but I don know much about Exel so I don't know how to
make my calculation sheet and do not show the ceros
thankyou

Max

One guess / way ..

To suppress extraneous zeros from showing on the sheet:
Click Tools Options View tab
Uncheck "Zero values" OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ana ibarra" <ana wrote in message
...
hi, please help me
I am doing a worksheet but I don know much about Exel so I don't know how
to
make my calculation sheet and do not show the ceros
thankyou

All times are GMT +1. The time now is 10:05 PM.