| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| xls worksheet formatting a single cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
