View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Wiley Wiley is offline
external usenet poster
 
Posts: 86
Default Why is one cell showing numbers in blue and how do I change th

Glad to help and thanks for the feedback.

"Echogrammy" wrote:

Wow! That was quick. The cursor did not change to a hand but I tried the
hyperlink tip anyway...not sure what or how I did it but the number is no
longer blue and is added in the total (maybe it was all along, I'm kind of a
novice, kinda like the first grader). Thank you, thank you, thank you. You've
solved several months of agony fo me and I was tired of looking and
experimenting.

"Wiley" wrote:

This may be a hyperlink. Does th ecrsor change to a hand when moved over the
cell? If so, click Insert/Hyperlink. Then click the Remove Hyperlink button.

"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?