• Answers
  • Web
Personalize Yedda, (And make Danny Happy)
People ask & answer about almost everything. Tell us what you're interested in... So we can personalize Yedda especially for you
I'm interested in:
Save
Cancel

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

Topics:

Share Send to a friend Watch Report
 
 

4 Posted Answers
Order by

 
223 answers
63 helpful answers

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

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 2008-01-15T14:08:00Z
Helpful?(0)
Rated #1 out of 4
 

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 2009-01-16T01:50:05Z
Helpful?(0)
Rated #2 out of 4
 

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.
Posted 2009-06-30T16:10:32Z
Helpful?(0)
Rated #3 out of 4
 

Select column you want to remove zero,click Data,Text to Columns,continue with next and you will done.
Posted 2009-07-13T21:01:30Z
Helpful?(0)
Rated #4 out of 4

Sign in to participate

Got an answer for irislbl? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Sign up for a free account, or sign in (if you're already a member).

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:


Q:

Sample Succession PLans in Excel FOrmat

Does anyone have ideas for excel sheet for succesion plans?
Submitted by careymm   4 months ago.
  • 0 answers
  • viewed 174 times
Be the first to answer


Q:

Excel 2007 - currency format part 2

i have a problem with the way Excel 07 interpretes Windows regional settings. With the Excel 07 file open and Windows regional ...
Submitted by harperj   1 year ago.
  • 0 answers
  • viewed 790 times
Be the first to answer


Q:

Excel 2007 - currency format

Excel 2007 automatically converts numerical values into the currency format. Every time I set the cells to "general" format it ...
Submitted by drabsv   3 years ago.
  • 2 answers
  • viewed 1070 times
Last answer posted 3 years ago by drabsv



» More...

Explore Related Posts in Forums

copy current excel data to a new excel file

HI, anyone know how to copy a range of data from current excel to a new excel or sheet1 to sheet2 ? how to read columns? Lets say, range A1:A15, A17:A27, etc.. to a new excel file/sheet. You can copy a sheet, by right click the sheet tab at the botttom of the excel workbook

Pivot Table: How to block users from opening the Excel Workbook in Excel ...

I habe used the Excel Services to show Users of the SharePoint site a Pivot Table. I would like the users not to be able to open the Excel Workbook in Excel itsself. How can I do this? setting in the workbook itself that affests this?You can uncheck the Open in Excel, Open Snapshot

[Excel] Excel process still running after mail merge completed and exited...

Hi, I've been trying to write some code in Excel that will open Word, perform a mail merge tried a similar thing, is that once I have saved and closed my spreeadsheet then quit Excel Is Word continuing to run in the background or Excel?Hi, Originally both were staying open until
» More...
Powered by
Feed - Subscribe to changes to this Q&A Blog
ADVERTISEMENT
  • Answers
  • Web
Copyright © 2006-2009, Yedda Inc. and respective copyright owners · CC License