| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
clear CELL "@" format
Cannot clear @ formate entered in a cell by mistake.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
clear CELL "@" format
What format do you want to have? You can't simply have no format, it either a
specified format or general (type "General", sans quotes). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "neville" wrote: Cannot clear @ formate entered in a cell by mistake. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
clear CELL "@" format
1. remove any protection from workbooks and worksheets
2. unlock all cells 3. click on the cell(s) and: Edit Clear Formats -- Gary''s Student - gsnu200907 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell such that "#NAME?" reads/appears "N/A"? | Excel Discussion (Misc queries) | |||
| If Cell = "XXX" Then clear all other cells formula | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
