I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane

Try widening the column or changing the font to something smaller.

And if the cell is formatted as time or date, then the value can't be negative
(except with a setting to use the 1904 date system).

Duplatt wrote:

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane

--

Dave Peterson

Dave, Thanks for responding: The font is 8, the format is General. Column
width and row height are ok. It was ok a few days ago. Formula's have not
changed. The correct number is there when the curser touches the cell. I'm
stumped
Duane

"Dave Peterson" wrote:

Try widening the column or changing the font to something smaller.

And if the cell is formatted as time or date, then the value can't be negative
(except with a setting to use the 1904 date system).

Duplatt wrote:

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane

--

Dave Peterson

Duplatt

Did you try to make the column wider or just check that it is the same width
as others? Sounds to me that if you accually drag the column wider, like
Dave suggested, it will show correctly.

Mike Rogers

"Duplatt" wrote:

Dave, Thanks for responding: The font is 8, the format is General. Column
width and row height are ok. It was ok a few days ago. Formula's have not
changed. The correct number is there when the curser touches the cell. I'm
stumped
Duane

"Dave Peterson" wrote:

Try widening the column or changing the font to something smaller.

And if the cell is formatted as time or date, then the value can't be negative
(except with a setting to use the 1904 date system).

Duplatt wrote:

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane

--

Dave Peterson

Mike, I have made the column full screen width. The # stays right in the
center of the cell. Thanks for you suggestion
Duane

"Mike Rogers" wrote:

Duplatt

Did you try to make the column wider or just check that it is the same width
as others? Sounds to me that if you accually drag the column wider, like
Dave suggested, it will show correctly.

Mike Rogers

"Duplatt" wrote:

Dave, Thanks for responding: The font is 8, the format is General. Column
width and row height are ok. It was ok a few days ago. Formula's have not
changed. The correct number is there when the curser touches the cell. I'm
stumped
Duane

"Dave Peterson" wrote:

Try widening the column or changing the font to something smaller.

And if the cell is formatted as time or date, then the value can't be negative
(except with a setting to use the 1904 date system).

Duplatt wrote:

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane

--

Dave Peterson

I got it !! Format - Style - Normal - OK
Don't know how or why but now it's OK
Thanks for your suggestions
Duane

"Duplatt" wrote:

Mike, I have made the column full screen width. The # stays right in the
center of the cell. Thanks for you suggestion
Duane

"Mike Rogers" wrote:

Duplatt

Did you try to make the column wider or just check that it is the same width
as others? Sounds to me that if you accually drag the column wider, like
Dave suggested, it will show correctly.

Mike Rogers

"Duplatt" wrote:

Dave, Thanks for responding: The font is 8, the format is General. Column
width and row height are ok. It was ok a few days ago. Formula's have not
changed. The correct number is there when the curser touches the cell. I'm
stumped
Duane

"Dave Peterson" wrote:

Try widening the column or changing the font to something smaller.

And if the cell is formatted as time or date, then the value can't be negative
(except with a setting to use the 1904 date system).

Duplatt wrote:

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane

--

Dave Peterson

Duplatt

Thanks for posting back, especially with the solution!!!! Its what makes
this site work for others when a possible solution is posted.

Mike Rogers

"Duplatt" wrote:

I got it !! Format - Style - Normal - OK
Don't know how or why but now it's OK
Thanks for your suggestions
Duane

"Duplatt" wrote:

Mike, I have made the column full screen width. The # stays right in the
center of the cell. Thanks for you suggestion
Duane

"Mike Rogers" wrote:

Duplatt

Did you try to make the column wider or just check that it is the same width
as others? Sounds to me that if you accually drag the column wider, like
Dave suggested, it will show correctly.

Mike Rogers

"Duplatt" wrote:

Dave, Thanks for responding: The font is 8, the format is General. Column
width and row height are ok. It was ok a few days ago. Formula's have not
changed. The correct number is there when the curser touches the cell. I'm
stumped
Duane

"Dave Peterson" wrote:

Try widening the column or changing the font to something smaller.

And if the cell is formatted as time or date, then the value can't be negative
(except with a setting to use the 1904 date system).

Duplatt wrote:

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane

--

Dave Peterson