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

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