Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stephen
 
Posts: n/a
Default pound signs cell formatting

I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet, tons, ect.
based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general or
text, the cell displays pound signs instead of the number because the number
is too large to fit into one cell. I'm using Excel 2000. Like I said, I've
already tried formatting it for general, and for text, and neither worked.
Does anyone know how to get my spreadsheet to display numbers?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default pound signs cell formatting

Stephen wrote:
I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet,
tons, ect. based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general
or text, the cell displays pound signs instead of the number because
the number is too large to fit into one cell. I'm using Excel 2000.
Like I said, I've already tried formatting it for general, and for
text, and neither worked. Does anyone know how to get my spreadsheet
to display numbers?


have you tried making the cell larger?


  #3   Report Post  
Posted to microsoft.public.excel.misc
Stephen
 
Posts: n/a
Default pound signs cell formatting

I have a half-tone border around every cell so that it creates an even grid
in the body of the sheet. I can't make the cell larger because I need to
keep the grid uniform.

"Paul Lautman" wrote:

Stephen wrote:
I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet,
tons, ect. based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general
or text, the cell displays pound signs instead of the number because
the number is too large to fit into one cell. I'm using Excel 2000.
Like I said, I've already tried formatting it for general, and for
text, and neither worked. Does anyone know how to get my spreadsheet
to display numbers?


have you tried making the cell larger?



  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default pound signs cell formatting

Could you decrease the number of decimals displayed?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Stephen" wrote in message
...
I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet, tons,
ect.
based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general or
text, the cell displays pound signs instead of the number because the
number
is too large to fit into one cell. I'm using Excel 2000. Like I said,
I've
already tried formatting it for general, and for text, and neither worked.
Does anyone know how to get my spreadsheet to display numbers?



  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR
 
Posts: n/a
Default pound signs cell formatting


Reduce the size of the font
Reduce the number of formatted decimals.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Stephen" wrote in message
...
I have a half-tone border around every cell so that it creates an even grid
in the body of the sheet. I can't make the cell larger because I need to
keep the grid uniform.

"Paul Lautman" wrote:

Stephen wrote:
I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet,
tons, ect. based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general
or text, the cell displays pound signs instead of the number because
the number is too large to fit into one cell. I'm using Excel 2000.
Like I said, I've already tried formatting it for general, and for
text, and neither worked. Does anyone know how to get my spreadsheet
to display numbers?


have you tried making the cell larger?







  #6   Report Post  
Posted to microsoft.public.excel.misc
Stephen
 
Posts: n/a
Default pound signs cell formatting

I don't have any decimals displayed...that shouldn't matter anyway. If I
have a number like 14,234.7, making it 14,234 isn't going to make it fit into
the cell any better, it will still be too big.

"Bernard Liengme" wrote:

Could you decrease the number of decimals displayed?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Stephen" wrote in message
...
I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet, tons,
ect.
based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general or
text, the cell displays pound signs instead of the number because the
number
is too large to fit into one cell. I'm using Excel 2000. Like I said,
I've
already tried formatting it for general, and for text, and neither worked.
Does anyone know how to get my spreadsheet to display numbers?




  #7   Report Post  
Posted to microsoft.public.excel.misc
Stephen
 
Posts: n/a
Default pound signs cell formatting

I can't reduce the size of the font, I need it to be uniform throughout the
sheet. It is for a report for a client. There are no decimals. I have
formatted it for general and it didn't work. Even when I formatted it for
number, any number of decimals didn't make it work. When I formatted it for
text it didn't work.

"RagDyeR" wrote:


Reduce the size of the font
Reduce the number of formatted decimals.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Stephen" wrote in message
...
I have a half-tone border around every cell so that it creates an even grid
in the body of the sheet. I can't make the cell larger because I need to
keep the grid uniform.

"Paul Lautman" wrote:

Stephen wrote:
I have a cell who's width is 2.43 and which contains a formula which
calculates any number of things, such as square feet, cubic feet,
tons, ect. based on which measurements are given. My formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for general
or text, the cell displays pound signs instead of the number because
the number is too large to fit into one cell. I'm using Excel 2000.
Like I said, I've already tried formatting it for general, and for
text, and neither worked. Does anyone know how to get my spreadsheet
to display numbers?


have you tried making the cell larger?






  #8   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default pound signs cell formatting

Stephen wrote:
I can't reduce the size of the font, I need it to be uniform
throughout the sheet. It is for a report for a client. There are no
decimals. I have formatted it for general and it didn't work. Even
when I formatted it for number, any number of decimals didn't make it
work. When I formatted it for text it didn't work.

"RagDyeR" wrote:


Reduce the size of the font
Reduce the number of formatted decimals.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Stephen" wrote in message
...
I have a half-tone border around every cell so that it creates an
even grid in the body of the sheet. I can't make the cell larger
because I need to keep the grid uniform.

"Paul Lautman" wrote:

Stephen wrote:
I have a cell who's width is 2.43 and which contains a formula
which calculates any number of things, such as square feet, cubic
feet, tons, ect. based on which measurements are given. My
formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for
general or text, the cell displays pound signs instead of the
number because the number is too large to fit into one cell. I'm
using Excel 2000. Like I said, I've already tried formatting it
for general, and for text, and neither worked. Does anyone know
how to get my spreadsheet to display numbers?

have you tried making the cell larger?


Look, the # signs are displayed because the characters with their current
size will not fit into the cell with its current size. If you didn't have
the # signs then you would have only part of the number which would be
meaningless anyway. So you have 2 choices:

1) make the cell larger
2) make the font smaller


  #9   Report Post  
Posted to microsoft.public.excel.misc
Stephen
 
Posts: n/a
Default pound signs cell formatting

Reducing the size only makes the pound signs smaller, it doesn't help fix the
problem. I have other cells formatted as text, but the cells contain
numbers. The numbers are large and don't fit into the cell, but it displays
the whole number anyway, it just overlaps into the next cell. I didn't have
to reduce the font size for that to work, and there are no decimal places in
the text formatting. My question is, is the formula contained in the cell
which displays the pound signs the reason the pound signs are being displayed
even though the cell is formatted exactly the same way as the ones with large
numbers in them that show up?

"Paul Lautman" wrote:

Stephen wrote:
I can't reduce the size of the font, I need it to be uniform
throughout the sheet. It is for a report for a client. There are no
decimals. I have formatted it for general and it didn't work. Even
when I formatted it for number, any number of decimals didn't make it
work. When I formatted it for text it didn't work.

"RagDyeR" wrote:


Reduce the size of the font
Reduce the number of formatted decimals.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Stephen" wrote in message
...
I have a half-tone border around every cell so that it creates an
even grid in the body of the sheet. I can't make the cell larger
because I need to keep the grid uniform.

"Paul Lautman" wrote:

Stephen wrote:
I have a cell who's width is 2.43 and which contains a formula
which calculates any number of things, such as square feet, cubic
feet, tons, ect. based on which measurements are given. My
formula is:

=IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V12*Y1 2))).

The problem I'm having is that even when it is formatted for
general or text, the cell displays pound signs instead of the
number because the number is too large to fit into one cell. I'm
using Excel 2000. Like I said, I've already tried formatting it
for general, and for text, and neither worked. Does anyone know
how to get my spreadsheet to display numbers?

have you tried making the cell larger?


Look, the # signs are displayed because the characters with their current
size will not fit into the cell with its current size. If you didn't have
the # signs then you would have only part of the number which would be
meaningless anyway. So you have 2 choices:

1) make the cell larger
2) make the font smaller



  #10   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default pound signs cell formatting

Stephen wrote:
Reducing the size only makes the pound signs smaller, it doesn't help
fix the problem.

It does once you make is small enough!

I've just come up with an idea. Try:

=TEXT(IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V 12*Y12))),"#")

Let me know if it works




  #11   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default pound signs cell formatting

"Paul Lautman" wrote in message
...
Stephen wrote:
I can't reduce the size of the font, I need it to be uniform
throughout the sheet. It is for a report for a client. There are no
decimals. I have formatted it for general and it didn't work. Even
when I formatted it for number, any number of decimals didn't make it
work. When I formatted it for text it didn't work.


Look, the # signs are displayed because the characters with their current
size will not fit into the cell with its current size. If you didn't have
the # signs then you would have only part of the number which would be
meaningless anyway. So you have 2 choices:

1) make the cell larger
2) make the font smaller


Or try scientific notation?
--
David Biddulph


  #12   Report Post  
Posted to microsoft.public.excel.misc
Stephen
 
Posts: n/a
Default pound signs cell formatting

Paul, that's awesome, it worked. Now, though, if I get a number too large
for cells S12, V12, or Y12 I get pound signs in those where I didn't before.
What's up with that? Do you have any suggestions. If not, thanks alot for
what you've done so far.

"Paul Lautman" wrote:

Stephen wrote:
Reducing the size only makes the pound signs smaller, it doesn't help
fix the problem.

It does once you make is small enough!

I've just come up with an idea. Try:

=TEXT(IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V 12*Y12))),"#")

Let me know if it works



  #13   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default pound signs cell formatting

Stephen wrote:
Paul, that's awesome, it worked. Now, though, if I get a number too
large for cells S12, V12, or Y12 I get pound signs in those where I
didn't before. What's up with that? Do you have any suggestions.

Not without seeing the sheet. Any chance you can post a copy of it on the
web somewhere?

If
not, thanks alot for what you've done so far.

"Paul Lautman" wrote:

Stephen wrote:
Reducing the size only makes the pound signs smaller, it doesn't
help fix the problem.

It does once you make is small enough!

I've just come up with an idea. Try:

=TEXT(IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V 12*Y12))),"#")

Let me know if it works




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
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Conditional Formatting For A Cell Other Than The One With The Form Jim J. Excel Worksheet Functions 2 February 19th 06 08:11 PM
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 24th 05 12:04 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
xls worksheet formatting a single cell Archer------------> Excel Discussion (Misc queries) 1 April 30th 05 07:25 PM


All times are GMT +1. The time now is 01:55 PM.

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

About Us

"It's about Microsoft Excel"