I have been working on a workbook, and have it almost finished, with the great help of some of you folks! What I want to know is how I can get the number 0 to appear in a cell, rather then it just going blank when a 0 is placed in it. It is important as the people completing the workbook will want to see that they have responded to a particular item. I also want the 0 to count as a response, which I think it does anyway, it just does not appear. Can anyone help. I think it is probably a simple calculation!! Thanks.
I am using Excel 2003 & when I palce a 0 in a cell the cell displays the 0
If I enter 0123 the cell will display 123
What version of Excel are you using?
How ids the cells formatting?
Is it the result of a formula?
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
It is Excel 2004 for the Mac. I have uploaded the workbook here if you care to take a look! Any help would be appreciated. Thanks.
On the Tools menu, click Options, and then click the View tab and see if the Zero values check box is ticked
- Portuga
There is no such thing as a problem, only a temporary lack of a solution
In formulas,you might need to replace ; with , depending on your XL version
I am using Excel 2004 for the Macintosh and there is not an "Options" choice in the tool bar? Is there any place else that this can be? I am stumped!
Found it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks