#1   Report Post  
Old November 18th 07, 01:31 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 33
Default # 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   Report Post  
Old November 18th 07, 01:40 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default # 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   Report Post  
Old November 18th 07, 04:11 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 33
Default # 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   Report Post  
Old November 18th 07, 04:18 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 284
Default # 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   Report Post  
Old November 18th 07, 04:51 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 33
Default # 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   Report Post  
Old November 18th 07, 05:16 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 33
Default # 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   Report Post  
Old November 18th 07, 06:33 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 284
Default # 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i change dollar sign to rupee sign in sales invoice vishal kohli Excel Discussion (Misc queries) 3 May 10th 07 02:06 PM
Why a plus sign after the equal sign? [email protected] Excel Discussion (Misc queries) 3 June 5th 06 06:42 PM
can I change the $ sign to a £ sign in an MS template? tony Excel Worksheet Functions 1 January 2nd 06 06:31 PM
XL invoice replace the dollar sign with euro sign Pamela casares New Users to Excel 2 December 16th 05 08:21 PM
-ve no with -1; positive with sign+ and 0 no sign? Tks. shirley Excel Worksheet Functions 1 November 23rd 05 06:14 AM


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017