If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
# sign
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 |
#2
|
|||
|
|||
# sign
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 |
#3
|
|||
|
|||
# sign
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 |
#4
|
|||
|
|||
# sign
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 |
#5
|
|||
|
|||
# sign
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 |
#6
|
|||
|
|||
# sign
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 |
#7
|
|||
|
|||
# sign
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 |
Thread Tools | |
Display Modes | |
|
|