View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Why is one cell showing numbers in blue and how do I change that?

Sounds like someone has made a hyperlink in that cell.

When you point to it does the cursor turn into a hand?

What happens when you click on it?

If it is a hyperlink, right-click on it and "Remove hyperlink"


Gord Dibben MS Excel MVP

On Wed, 16 Aug 2006 11:16:43 -0700, Echogrammy
wrote:

In a large spreadsheet I have one cell in one column that shows up blue with
an underline beneath the number. I do not think that number is included in
my sum. I have tried several ways but have been unable to change it to a
normal number. Does anybody know how I can change this?