| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does #### indicate in a spreadsheet?
I'm working on a paper and I'm asked what #### means in an Excel spreadsheet.
Can anyone help me??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does #### indicate in a spreadsheet?
AFAIK it can mean one of two things:
1) the column is not currently wide enough to display the (numeric) value completely. Widening the column will allow the numeric value to display properly. 2) Excel can't display negative times. If a formula results in a negative time, #### will display. HTH, "allybell1980" wrote in message ... I'm working on a paper and I'm asked what #### means in an Excel spreadsheet. Can anyone help me??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does #### indicate in a spreadsheet?
It means the column is not wide enough to display all of the entry in the
cell. Solution is simple: make the column wider (or the text smaller). "allybell1980" wrote: I'm working on a paper and I'm asked what #### means in an Excel spreadsheet. Can anyone help me??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does #### indicate in a spreadsheet?
It could mean a few things.
1. The columnwidth is too narrow to show the number. Widen the column or change the font size of that cell. Or change the numberformat to General. 2. You have a date/time in that cell and it's negative Don't use negative dates. If excel was helping you, it may have changed the format to a date. Change it back to General (or some other number format). If you need to see negative date/times: Tools|options|Calculation Tab|and check 1904 date system (but this can cause trouble--watch what happens to your dates and watch what happens when you copy|paste dates to a different workbook that doesn't use this setting) 3. You have a lot of text in the cell, the cell is formatted as Text. Format the cell as general. 4. You really have ###'s in that cell. Clean up that cell. 5. You have # in a cell, but it's format is set to Fill. Change the format (format|cells|alignment tab|horizontal box, change it to General. allybell1980 wrote: I'm working on a paper and I'm asked what #### means in an Excel spreadsheet. Can anyone help me??? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does #### indicate in a spreadsheet?
The most common reason is that the text to display is too wide for the
cell. ### is also displayed when a time is entered as a negative number (1900 date format only - the 1904 format can display negative times). In article , allybell1980 wrote: I'm working on a paper and I'm asked what #### means in an Excel spreadsheet. Can anyone help me??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
