Unwanted number signs

Hi JC

i'm guessing at some point in its life that cell contained a date ...

to fix it, right mouse click on the cell
choose format / cells
under the number tab, choose text
click on the OK

Let us know how you go.

Cheers
JulieD

"JC" wrote in message
...
I typed in a cell a string of text which can be seen in the box on top of
the spreadsheet. However, in the cell itself, Excel returns a string of
number sign like "###################################..." The number signs
expand when the column width is expanded.

Can someone tell me what to do to display the text content in the cell?
Thanks!

Hi JC

cutting & pasting that worked fine for me ... mmm, if you want to, remove
the "remove this" out of my email address and email the sheet with the
problem to me & i'll have a look (but you'll need to do it asap as it's
1.24am here so i'm off to bed soon)

Cheers
JulieD

"JC" wrote in message
...
Hi Julie, the text does not contained a date and the the procedures
suggested did not work. Here is the content of the text. I hope you can
identify the problem. Thanks.
JC

Series A - "refer to data in column I of adjstd navps data tab ", Series
B - "refer to data in column I of adjstd navps data tab ", Series F -
"refer to data in column I of adjstd navps data tab ", Series I - "refer
to data in column I of adjstd navps data tab " in Canadian dollars, and

----- JulieD wrote: -----

Hi JC

i'm guessing at some point in its life that cell contained a date ...

to fix it, right mouse click on the cell
choose format / cells
under the number tab, choose text
click on the OK

Let us know how you go.

Cheers
JulieD

"JC" wrote in message
...
I typed in a cell a string of text which can be seen in the box on
top of
the spreadsheet. However, in the cell itself, Excel returns a string
of
number sign like "###################################..." The
number signs
expand when the column width is expanded.
Can someone tell me what to do to display the text content in the
cell?
Thanks!

When I tried to create a sample data file by using edit/move or copy sheet, the problem went away in the new file. Copy and paste it back the original file worked fine. So, I guess it's fixed although I still can't figure out why... Anyway, thanks a lot for your help.
Good night, Julie.
JC

----- JulieD wrote: -----

Hi JC

cutting & pasting that worked fine for me ... mmm, if you want to, remove
the "remove this" out of my email address and email the sheet with the
problem to me & i'll have a look (but you'll need to do it asap as it's
1.24am here so i'm off to bed soon)

Cheers
JulieD

"JC" wrote in message
...
Hi Julie, the text does not contained a date and the the procedures
suggested did not work. Here is the content of the text. I hope you can
identify the problem. Thanks.
JC
Series A - "refer to data in column I of adjstd navps data tab ", Series
B - "refer to data in column I of adjstd navps data tab ", Series F -
"refer to data in column I of adjstd navps data tab ", Series I - "refer
to data in column I of adjstd navps data tab " in Canadian dollars, and
----- JulieD wrote: -----
Hi JC
i'm guessing at some point in its life that cell contained a date ...
to fix it, right mouse click on the cell
choose format / cells
under the number tab, choose text
click on the OK
Let us know how you go.
Cheers
JulieD
"JC" wrote in message
...
I typed in a cell a string of text which can be seen in the box on
top of
the spreadsheet. However, in the cell itself, Excel returns a string
of
number sign like "###################################..." The
number signs
expand when the column width is expanded.
Can someone tell me what to do to display the text content in the
cell?
Thanks!

Hi JC

that's the sort of problems i like - the ones that solve themselves

Cheers
JulieD

"JC" wrote in message
...
When I tried to create a sample data file by using edit/move or copy
sheet, the problem went away in the new file. Copy and paste it back the
original file worked fine. So, I guess it's fixed although I still can't
figure out why... Anyway, thanks a lot for your help.
Good night, Julie.
JC

----- JulieD wrote: -----

Hi JC

cutting & pasting that worked fine for me ... mmm, if you want to,
remove
the "remove this" out of my email address and email the sheet with
the
problem to me & i'll have a look (but you'll need to do it asap as
it's
1.24am here so i'm off to bed soon)

Cheers
JulieD

"JC" wrote in message
...
Hi Julie, the text does not contained a date and the the procedures
suggested did not work. Here is the content of the text. I hope you
can
identify the problem. Thanks.
JC
Series A - "refer to data in column I of adjstd navps data tab
", Series
B - "refer to data in column I of adjstd navps data tab ", Series
F -
"refer to data in column I of adjstd navps data tab ", Series I -
"refer
to data in column I of adjstd navps data tab " in Canadian dollars,
and
----- JulieD wrote: -----
Hi JC
i'm guessing at some point in its life that cell contained a
date ...
to fix it, right mouse click on the cell
choose format / cells
under the number tab, choose text
click on the OK
Let us know how you go.
Cheers
JulieD
"JC" wrote in message
...
I typed in a cell a string of text which can be seen in the box on
top of
the spreadsheet. However, in the cell itself, Excel returns a
string
of
number sign like "###################################..."
The
number signs
expand when the column width is expanded.
Can someone tell me what to do to display the text content in the
cell?
Thanks!

JC

Ususally, changing the cell's format to General will fix this.

Gord Dibben Excel MVP

On Mon, 29 Mar 2004 09:21:06 -0800, "JC"
wrote:

Hi Julie, the text does not contained a date and the the procedures suggested did not work. Here is the content of the text. I hope you can identify the problem. Thanks.
JC

Series A - "refer to data in column I of adjstd navps data tab ", Series B - "refer to data in column I of adjstd navps data tab ", Series F - "refer to data in column I of adjstd navps data tab ", Series I - "refer to data in column I of adjstd navps data tab " in Canadian dollars, and

----- JulieD wrote: -----

Hi JC

i'm guessing at some point in its life that cell contained a date ...

to fix it, right mouse click on the cell
choose format / cells
under the number tab, choose text
click on the OK

Let us know how you go.

Cheers
JulieD

"JC" wrote in message
...
I typed in a cell a string of text which can be seen in the box on top of
the spreadsheet. However, in the cell itself, Excel returns a string of
number sign like "###################################..." The number signs
expand when the column width is expanded.
Can someone tell me what to do to display the text content in the cell?
Thanks!

Excel has trouble showing long strings when the cell is formatted as text (see
Gord's suggestion).

And when you copied that sheet, excel truncated the long string to 255
characters. That's why the problem went away in the test worksheet.

If the problem recurs, try changing the format from Text to General.



JC wrote:

When I tried to create a sample data file by using edit/move or copy sheet, the problem went away in the new file. Copy and paste it back the original file worked fine. So, I guess it's fixed although I still can't figure out why... Anyway, thanks a lot for your help.
Good night, Julie.
JC

----- JulieD wrote: -----

Hi JC

cutting & pasting that worked fine for me ... mmm, if you want to, remove
the "remove this" out of my email address and email the sheet with the
problem to me & i'll have a look (but you'll need to do it asap as it's
1.24am here so i'm off to bed soon)

Cheers
JulieD

"JC" wrote in message
...
Hi Julie, the text does not contained a date and the the procedures
suggested did not work. Here is the content of the text. I hope you can
identify the problem. Thanks.
JC
Series A - "refer to data in column I of adjstd navps data tab ", Series
B - "refer to data in column I of adjstd navps data tab ", Series F -
"refer to data in column I of adjstd navps data tab ", Series I - "refer
to data in column I of adjstd navps data tab " in Canadian dollars, and
----- JulieD wrote: -----
Hi JC
i'm guessing at some point in its life that cell contained a date ...
to fix it, right mouse click on the cell
choose format / cells
under the number tab, choose text
click on the OK
Let us know how you go.
Cheers
JulieD
"JC" wrote in message
...
I typed in a cell a string of text which can be seen in the box on
top of
the spreadsheet. However, in the cell itself, Excel returns a string
of
number sign like "###################################..." The
number signs
expand when the column width is expanded.
Can someone tell me what to do to display the text content in the
cell?
Thanks!


--

Dave Peterson