| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock formatting
Hi, how can I set up a cell/group of cells so that the data in them can be
changes but the formatting cannot. For instance if I put the number formatting as a percentage to 5 decimal places, then even if someone copy/pastes something from a different cell that is not in that format, the cell will take the new input without taking the formatting... Thanks HF |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lock in formatting on a worksheet | Excel Discussion (Misc queries) | |||
| How can I Lock Formatting? | Excel Worksheet Functions | |||
| Lock just formatting? | Excel Discussion (Misc queries) | |||
| Lock in formatting | Excel Worksheet Functions | |||
| How to lock worksheet formatting? | Excel Worksheet Functions | |||
Threaded Mode
