| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell not displaying as expected
GS wrote:
Terry Pinnell wrote: Claus Busch wrote: Hi Terry, Am Sat, 20 Jan 2018 11:25:46 +0000 schrieb Terry Pinnell: Why does the date in B6 not display fully, by overlapping into the next col, like B1, B2, B3, etc? C6 etc have General format. No wrap enabled on B6, C6, etc. https://www.dropbox.com/s/58itk1jlq3...ay-01.jpg?dl=0 only text will overlap if it is longer. If numbers are longer than the cell width you see only the number signs. Regards Claus B. Thanks for the fast solution, Claus. That was nagging me for ages this morning! Terry, East Grinstead, UK But before I give up (I don't want to manually widen the column) is there some way I can achieve it with a formula or VBA please? IOW, if I type say 09/08/17 into B6, with cells empty to the right as shown, is it possible to automatically display that in full? Especially if I decide to apply a lengthier format such as 'dddd dd mmm yyyy', giving 'Saturday 20 January 2018'. Terry, East Grinstead, UK Unfortunately, Excel requires an appropriate col width to display a date in a chosen display format. It would be nice if we had the ability to show ellipses when cell contents extend beyond the border, and a popup note appear when we mouse over as does my fpSpread.ocx I use to duplicate my Excel apps as stand-alone win.EXEs. Thanks for both replies, Garry. Terry, East Grinstead, UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal points data not displaying as expected | Excel Discussion (Misc queries) | |||
| displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
![Terry Pinnell[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
