View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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