| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove zeros from a linked blank cell?
When linking two worksheets, all of my blank cells (source worksheet),
display a zero (destination workshhet). How do I get them to display as blank cells in the destination worksheet? I am using Excel 2003 SP3. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove zeros from a linked blank cell?
=if('sheet 99'!a1="","",'sheet 99'!a1)
Scott wrote: When linking two worksheets, all of my blank cells (source worksheet), display a zero (destination workshhet). How do I get them to display as blank cells in the destination worksheet? I am using Excel 2003 SP3. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove zeros from a linked blank cell?
Is there a way to keep the formatting from the source spreadsheet? If I use
the If statement below, it wipes out the formatting (shading) from the original cell. "Dave Peterson" wrote: =if('sheet 99'!a1="","",'sheet 99'!a1) Scott wrote: When linking two worksheets, all of my blank cells (source worksheet), display a zero (destination workshhet). How do I get them to display as blank cells in the destination worksheet? I am using Excel 2003 SP3. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove zeros from a linked blank cell?
Formulas don't return this kind of formatting. They return values.
You could copy|paste or have a macro do it. Scott wrote: Is there a way to keep the formatting from the source spreadsheet? If I use the If statement below, it wipes out the formatting (shading) from the original cell. "Dave Peterson" wrote: =if('sheet 99'!a1="","",'sheet 99'!a1) Scott wrote: When linking two worksheets, all of my blank cells (source worksheet), display a zero (destination workshhet). How do I get them to display as blank cells in the destination worksheet? I am using Excel 2003 SP3. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need linked cell to be blank not 0 | Excel Discussion (Misc queries) | |||
| Remove leading zeros | Excel Discussion (Misc queries) | |||
| Return a blank cell instead of a zero value for two linked sheets. | Excel Discussion (Misc queries) | |||
| Remove Civic numbers in Street Address, move to previous blank cell | Excel Worksheet Functions | |||
| Remove zeros | Excel Worksheet Functions | |||
Linear Mode
