Posted by irislbl 5 years ago In:

excel

How to remove the "zero" value in excel file for ...

how to remove the "zero" value in excel file for Window Vista? I have no problem in doing this for Window XP but having problem in searching this function in Vista. Please help me if you know it.

Answer this question

Liked this question? Tell your friends about it

Facebook Windows Live Yahoo Twitter Digg Google del.icio.us Reddit

Link

Embed

Copy and paste the text above to share this Q&A

4 Answers

Order by: Oldest to Newest; Newest to Oldest; Votes

Lior Haner Answered:

If I understood you correctly, you want to hide the number 0 without deleting the formula on that cell.

I have tried it in excel 2007 (the newest version) and it should work on all versions of excel and windows.

Choose the cells you want, right click and then choose format cell. Choose the number tab and click on custom on the list you get. Type this into the text box: 0;-0;;@

This information also appears on a help page on the office support site.

Posted 4 years ago

No day in which you learn something is a complete loss.

Add a comment

Helpful? (0)

Report

numberman Answered:

If you are using Excel 2007, go to Excel Options, Advanced tab, under the Display section, there is an option "Show a zero in cells that have a zero value", just uncheck it.

Posted 3 years ago

Add a comment

Helpful? (0)

Report

Kenan Answered:

Remove 0 in excel. 1.Open new sheet, 2.Copy data in the column from ur old sheet, 3.Right click in the new sheet, 4.Paste special, 5.Under the Operation select Add, 6.Now same way to return beck ur data to old sheet. Note: if u have data with symbols, 0123456+ or - or ?,remove that symbols.