| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Alternate method.
Custom Format with ;;; the cells to look blank. Note: in either method you can still see the value in the Formula bar. You could hide it there also if you select those cells and FormatCellsProtectionHidden. Then protect the worksheet. Gord Dibben Excel MVP On Wed, 12 Jan 2005 14:15:04 -0800, "garpavco" wrote: thanks Trevor, makes sense! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
