I know how to go into options, advanced and get rid of zeros in a sheet, but every time I close the file and then reopen it, the zeros are back and I have to continually reselect the option for each sheet. Is there a way to make that option permanent in a workbook or sheet so they never show up?
Are formulas in the cells that gives you 0 values?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
just a link to another cell that has nothing in it. EX: =LEGS!B6.
Is the cell format Number? If it is then excel will populate it with a Zero automatically I think.
OOO. Sorry i haven't see your message.
Or maybe, this, will do the job.
=if(LEGS!B6="","",LEGS!B6)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks