| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Symbol Insertion In Cell
I am trying to have the "Inch" symbol automatically inserted into a cell when
I type in a number. For example, if I type a 12 in a cell, the Inch (") symbol will automatically appear in front of that number. Please advise |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Symbol Insertion In Cell
Custom Format of 0"''"
That is double quote, two single quotes, double quote Gord Dibben MS Excel MVP On Thu, 14 Aug 2008 14:41:02 -0700, Microconfusion wrote: I am trying to have the "Inch" symbol automatically inserted into a cell when I type in a number. For example, if I type a 12 in a cell, the Inch (") symbol will automatically appear in front of that number. Please advise |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic insertion of page breaks | Excel Discussion (Misc queries) | |||
| Automatic hyperlink insertion. | Links and Linking in Excel | |||
| Automatic row insertion | Excel Discussion (Misc queries) | |||
| Automatic Date Insertion? | Excel Worksheet Functions | |||
| how to delete automatic 'copyright' symbol insertion | Excel Discussion (Misc queries) | |||
Hybrid Mode
