| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same info from one column to different columns in multiple wor
To not show 0 values: Tools, Options, View, and unselect Zero values (in the
middle near the bottom). "B_K" wrote: Thank you for all your replies! Just one more question... when I paste the formula in the row with a blank cell, a "0" appears in the cell... is there some ways to get rid of the "0"? I know I can just skip that blank cell and not paste the formula in there, but I want to paste the formula in the blank cells too for consistency. Thanks! -- B_K ------------------------------------------------------------------------ B_K's Profile: http://www.excelforum.com/member.php...o&userid=33874 View this thread: http://www.excelforum.com/showthread...hreadid=536535 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to merge data from multiple columns to one column | Excel Discussion (Misc queries) | |||
| Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
| Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| MERGING COLUMNS WITH DUPLICATE INFO. | Excel Worksheet Functions | |||
Threaded Mode
