Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide negative numbers in Excel
Hi I am working on real simple spreadsheet in Excel I have a little problem.
I do not want to show negative numbers. For my spread sheet a negative is mute so it is not needed. Any way to hide them? Thank you, James |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide negative numbers in Excel
James,
You could use a custom format of "General;" (without the quotes) but the negative value will still be in the cell and so will be used in any future calculations. You could also add to yojur formula as in: =IF(your formula <0,0,your formula) or IF(your formula<0,"",your formula) but in the second version the empty string may cause you problems if you use it in other formulas. -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "James" wrote in message ... Hi I am working on real simple spreadsheet in Excel I have a little problem. I do not want to show negative numbers. For my spread sheet a negative is mute so it is not needed. Any way to hide them? Thank you, James |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide negative numbers in Excel
You can set Conditional Formatting to turn the font color to white when
the number is less than zero. The white font will not appear on screen or on prints. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide negative numbers in Excel
You could hide the negative values with conditional formatting;
If the value is less than 0 then the text colour is white (assuming you have a white backround) DO: Format conditional Formatting then select is less than for cell value and enter 0 then click format and text colour as white. Hope that helps "James" wrote: Hi I am working on real simple spreadsheet in Excel I have a little problem. I do not want to show negative numbers. For my spread sheet a negative is mute so it is not needed. Any way to hide them? Thank you, James |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide negative numbers in Excel
Hi James
You could also use custom cell format 0,"" (or is it 0;"" ? I'm not sure if a semicolon is the thing here or if it's language dependant) HTH. Best wishes Harald "James" skrev i melding ... Hi I am working on real simple spreadsheet in Excel I have a little problem. I do not want to show negative numbers. For my spread sheet a negative is mute so it is not needed. Any way to hide them? Thank you, James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FedEx tracking numbers in Excel | Excel Discussion (Misc queries) | |||
Brackets or paranthesis around negative numbers in Excel | New Users to Excel | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
Can I calculate negative numbers to = zero in excel? | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) |