| 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? |
| 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) | |||
Threaded Mode
