View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Annoying single quote with ever new workbook

Hi oldtimer

In every cell in each new workbook ???

If you look in your XLstart folder is there aworkbook named Book.xlt ??
Try to move it out of the XLstart folder

Where it is: C:\Documents and Settings\<User\Application Data\Microsoft\Excel\XLSTART

With code you find the path with this line
MsgBox Application.StartupPath


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"oldtimer" wrote in message ...
Whenever I start a new workbook, if I enter text into a cell and press enter,
in the formula bar the text is preceded with a single quote. I have obviously
switched something on somewhere for this to happen. I know I can do a
Find/Replace, but I dont want to do this for every workbook I produce. Does
anybody know how to switch it off?