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?

hi,

check conditional format

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Echogrammy" escreveu:

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?

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?

Wow...that was quick! However, maybe I did not give you enough info. (I'm
kind of like the first grader here with Excel). When you said to check
conditional format I had deleted the "blue number", kept the cell selected
and clicked on conditional format and did not understand anything in that
little window. When I put the number back in (it always comes up blue) the
unconditional format is not available to click on, as is the hyperlink which
was suggested by another person. Am I making sense?

"Marcelo" wrote:

hi,

check conditional format

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Echogrammy" escreveu:

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?

Hi, yes it could be a hyperlink, if its true just right click and remove the
hyperlink,
or did you try to format the font?

to check de cond format select that cell, format | conditional Format and
see if there any rules to format the figure blue.

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Echogrammy" escreveu:

Wow...that was quick! However, maybe I did not give you enough info. (I'm
kind of like the first grader here with Excel). When you said to check
conditional format I had deleted the "blue number", kept the cell selected
and clicked on conditional format and did not understand anything in that
little window. When I put the number back in (it always comes up blue) the
unconditional format is not available to click on, as is the hyperlink which
was suggested by another person. Am I making sense?

"Marcelo" wrote:

hi,

check conditional format

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Echogrammy" escreveu:

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?

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?

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?

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?