Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to ### when next cell is blank - why?
When I enter the date and it is longer than the column I'm working in, it
usually just shows up flowing over the next cell, which is blank. However, once in awhile instead of showing the date, I get #### instead - even though the next cell is blank. WHY? I don't want to change the width of the date cell as this will throw off the rest of the spreadsheet.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to ### when next cell is blank - why?
My guess is that the next cell isn't really blank, but perhaps contains a
space or an empty string. If you don't want to make the column wider, another option is to make the font size smaller. The other cause of getting a #### result from what you hope is a date is if you are trying to show a negative number as date or time. In this case you may get somewhere by changing to 1904 date format, but beware of consequences when you try to push data to & fro between sheets with different date options. -- David Biddulph "pamjmac27" wrote in message ... When I enter the date and it is longer than the column I'm working in, it usually just shows up flowing over the next cell, which is blank. However, once in awhile instead of showing the date, I get #### instead - even though the next cell is blank. WHY? I don't want to change the width of the date cell as this will throw off the rest of the spreadsheet.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to ### when next cell is blank - why?
"pamjmac27" wrote in message
... When I enter the date and it is longer than the column I'm working in, it usually just shows up flowing over the next cell, which is blank. However, once in awhile instead of showing the date, I get #### instead - even though the next cell is blank. WHY? I don't want to change the width of the date cell as this will throw off the rest of the spreadsheet.. The adjacent cell ISN'T blank, then. It may appear blank, but it isn't. It may contain a space. It may be formatted with white font on white background. It may contain a value of zero and zero values are set not to be displayed. It may contain a null text string "". It may contain a formula returning any of these. There are probably other possibilities also. What's certain is that it isn't blank! Try copying one of the 'adjacent' cells in a row where data from the cell to the left appears over it as you expect (which is therefore definitely blank) and pasting this onto the cell that you think is blank. You will see that it makes a difference. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to ### when next cell is blank - why?
Numbers (including dates) won't overflow into adjacent cells.
Maybe you could change the font. pamjmac27 wrote: When I enter the date and it is longer than the column I'm working in, it usually just shows up flowing over the next cell, which is blank. However, once in awhile instead of showing the date, I get #### instead - even though the next cell is blank. WHY? I don't want to change the width of the date cell as this will throw off the rest of the spreadsheet.. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to ### when next cell is blank - why?
You may want to use:
Format|Cells|Alignment tab|Check the "Shrink to Fit" box. If the problem only occurs on certain dates, you may not even not a dramatic change in font size. Dave Peterson wrote: Numbers (including dates) won't overflow into adjacent cells. Maybe you could change the font. pamjmac27 wrote: When I enter the date and it is longer than the column I'm working in, it usually just shows up flowing over the next cell, which is blank. However, once in awhile instead of showing the date, I get #### instead - even though the next cell is blank. WHY? I don't want to change the width of the date cell as this will throw off the rest of the spreadsheet.. -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to ### when next cell is blank - why?
A date is a number.
Numbers won't stretch across into an adjacent even if the adjacent cell is empty. If you have dates that stretch across, they are text and not real dates. Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 08:04:01 -0800, pamjmac27 wrote: When I enter the date and it is longer than the column I'm working in, it usually just shows up flowing over the next cell, which is blank. However, once in awhile instead of showing the date, I get #### instead - even though the next cell is blank. WHY? I don't want to change the width of the date cell as this will throw off the rest of the spreadsheet.. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date changes to ### when next cell is blank - why?
That was the answer - thank you. When I change the cell's format to 'Text'
it works perfectly. "Gord Dibben" wrote: A date is a number. Numbers won't stretch across into an adjacent even if the adjacent cell is empty. If you have dates that stretch across, they are text and not real dates. Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 08:04:01 -0800, pamjmac27 wrote: When I enter the date and it is longer than the column I'm working in, it usually just shows up flowing over the next cell, which is blank. However, once in awhile instead of showing the date, I get #### instead - even though the next cell is blank. WHY? I don't want to change the width of the date cell as this will throw off the rest of the spreadsheet.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to use a different cell if my date field is NULL/BLANK | Excel Worksheet Functions | |||
to enter today's date if a cell is blank | Excel Worksheet Functions | |||
Using Date & Time Custom Cell - Need to show blank! | Excel Discussion (Misc queries) | |||
date of corresponding blank cell | Excel Discussion (Misc queries) | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions |