zero values

cpc

New Member
Joined
Mar 14, 2002
Messages
38
I have a problem with zero values. I want
a zero value, or actually the number 0.00
to show in a cell and to be used as a number in a formula. The problem is I need the form to be "without zero values", but need this "0.00" to appear in only the one cell.

Is this possible? Help!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
On 2002-03-26 19:32, cpc wrote:
I have a problem with zero values. I want
a zero value, or actually the number 0.00
to show in a cell and to be used as a number in a formula. The problem is I need the form to be "without zero values", but need this "0.00" to appear in only the one cell.

Is this possible? Help!

It's possible. Run this macro on your sheet:

Sub HideThoseZeros()

ActiveWindow.DisplayZeros = True
Cells.NumberFormat = "0;-0;;@"
Range("A1").NumberFormat = "0.00"

End Sub

Just replace "A1" with whatever Cell address you had in mind. You can also do this manually, but since I don't know your language packet this should do it...
This message was edited by Sbirro Cornuto on 2002-03-27 00:34
 
Upvote 0
Dave Hawley, regarding zero values
the form is simply a workbook in excel.

Sbirro, Yes is there a way to do this manually? The language? What do you mean?
English? Can this be done with out VBA?
 
Upvote 0
Use Custom Formatting in the cell you wish to display the 0.00.In the dialog box, enter ";;0.00;" This will display zero as 0.00 Now enter a zero in that cell. You can turn off the display zeros for all other cells under tools options
 
Upvote 0
Hi cps


If it's only one cell you want to show zero as 0.00 while all others are hidden, try:
="0.00"

With the Tools>option-View-Zero values Off


If you need the value in a Function just times by 1 first.
 
Upvote 0
Yes you can do it manually, set your sheet to display zeros, select all the Cells and change the number format to 0;-0;;@, then go to the Cell you desire to Display zeros in 0.00 format and change it's number format to 0.00. I wanted to know your language packet cause I have propably the only Italiano Excel in NYC and though can't advice you step by step if you don't have that...
This message was edited by Sbirro Cornuto on 2002-03-27 07:22
 
Upvote 0
Oh yes, this is getting all nice and confusing. The main point is as follows:

If you have the WorkBook View-Zero values turned Off, it wont so you the zero values. So you want to turn it on and then go to Sheet's Cells and change the Number Formating in those to "0;-0;;@" so they wont show zeros, except the one you want to show zeros, you change it's Number Formating to "0.00" and there you have it.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,217
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top