Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide/Don't Display Values
I have a secondary spreadsheet that obtains its values (text and numbers)
from a primary spreadsheet. Since some of the values in the primary spreadsheet are blank, the secondary spreadsheet displays "0" for blank text and $0.00 for blank numbers. How do I hide these values in the spreadsheet, without losing the formulas? I want to make sure that the values can be seen in the secondary spreadsheet in the future if any valid values are entered. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide/Don't Display Values
=IF(Sheet2!A1="","",Sheet2!A1)
-- Regards, Peo Sjoblom "Mike" wrote in message ... I have a secondary spreadsheet that obtains its values (text and numbers) from a primary spreadsheet. Since some of the values in the primary spreadsheet are blank, the secondary spreadsheet displays "0" for blank text and $0.00 for blank numbers. How do I hide these values in the spreadsheet, without losing the formulas? I want to make sure that the values can be seen in the secondary spreadsheet in the future if any valid values are entered. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide/Don't Display Values
=IF(Primary!A1<"",Primary!A1,"")
etc. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike" wrote in message ... I have a secondary spreadsheet that obtains its values (text and numbers) from a primary spreadsheet. Since some of the values in the primary spreadsheet are blank, the secondary spreadsheet displays "0" for blank text and $0.00 for blank numbers. How do I hide these values in the spreadsheet, without losing the formulas? I want to make sure that the values can be seen in the secondary spreadsheet in the future if any valid values are entered. Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide/Don't Display Values
Consider an easy way?
Just suppress the display of zeros in the sheet via: Tools Options View tab Uncheck "Zero values" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mike" wrote: I have a secondary spreadsheet that obtains its values (text and numbers) from a primary spreadsheet. Since some of the values in the primary spreadsheet are blank, the secondary spreadsheet displays "0" for blank text and $0.00 for blank numbers. How do I hide these values in the spreadsheet, without losing the formulas? I want to make sure that the values can be seen in the secondary spreadsheet in the future if any valid values are entered. Thank you. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide/Don't Display Values
Thank you so much. Works great!
"Peo Sjoblom" wrote: =IF(Sheet2!A1="","",Sheet2!A1) -- Regards, Peo Sjoblom "Mike" wrote in message ... I have a secondary spreadsheet that obtains its values (text and numbers) from a primary spreadsheet. Since some of the values in the primary spreadsheet are blank, the secondary spreadsheet displays "0" for blank text and $0.00 for blank numbers. How do I hide these values in the spreadsheet, without losing the formulas? I want to make sure that the values can be seen in the secondary spreadsheet in the future if any valid values are entered. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a formula to hide/ display row based on cell value in Exc | Excel Worksheet Functions | |||
I am trying to hide or display the scroll bars in Excell 2007. | Excel Discussion (Misc queries) | |||
hide values and display a decimal point that fills the cell | Excel Worksheet Functions | |||
Automate display/ hide rows in excel based on yes/no check box | Excel Discussion (Misc queries) | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |