Thread: smart tags
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default smart tags

Louise

What you see are not Smart Tags

Go to ToolsOptionsError Checking and checkmark "enable error checking"


Gord Dibben MS Excel MVP

On Thu, 2 Nov 2006 02:11:02 -0800, Louise
wrote:

my colleague and I both have Office 2003. The Smart Tags on my PC seem to be
working differently to my colleagues. On mine,if any numbers have been
stored as text, it flags them up with a smart tag and I can quickly convert
them to numbers, however, on his PC, they are not flagged so he doesn't know
when they are stored as text and can't convert them.

I have checked Tools Auto-Correct and Smart Tags our options seem to be the
same. (I have no tick for 'label data with smart tags' and neither does he?)

Is there another setting which may have switched his smart tags off
permanenty which I can get back?

Thank you.

Louise