Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doesn't this content get fully displayed?
I raised this early in December and I thought I'd sort of answered it
myself... But on returning to it today I still don't really understand why cell b6 get doesn't get fully displayed as 'Saturday 21 January 2017', stretching into column C, like the cells above? (C6 is empty, of course.) https://dl.dropboxusercontent.com/u/...l-Confined.jpg P.S. to Claus: I'm successfully using the excellent macro you wrote for me last August in the thread 'Customising date format', and can convert that cell quickly to 'Saturday 21st January 2017'. So it's frustrating that I can't display it! -- Terry, East Grinstead, UK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doesn't this content get fully displayed?
Hi Terry,
Am Sun, 22 Jan 2017 15:57:37 +0000 schrieb Terry Pinnell: I raised this early in December and I thought I'd sort of answered it myself... But on returning to it today I still don't really understand why cell b6 get doesn't get fully displayed as 'Saturday 21 January 2017', stretching into column C, like the cells above? (C6 is empty, of course.) thats the behaviour of a numbers and dates. Only text will extend to the cell of the right if this cell is empty. If columns are too small numbers are shown in scientific format and dates as number signs. You have to enlarge the columns width or create a text formatted date if you don't have to calcualte with. Regards Claus B. -- Windows10 Office 2016 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doesn't this content get fully displayed?
Claus Busch wrote:
Hi Terry, Am Sun, 22 Jan 2017 15:57:37 +0000 schrieb Terry Pinnell: I raised this early in December and I thought I'd sort of answered it myself... But on returning to it today I still don't really understand why cell b6 get doesn't get fully displayed as 'Saturday 21 January 2017', stretching into column C, like the cells above? (C6 is empty, of course.) thats the behaviour of a numbers and dates. Only text will extend to the cell of the right if this cell is empty. If columns are too small numbers are shown in scientific format and dates as number signs. You have to enlarge the columns width or create a text formatted date if you don't have to calcualte with. Regards Claus B. Thanks Claus, understood. A disappointing limitation IMO. I can't use one of the obvious solutions so my workaround is to temporarily widen col B and use an OCR tool to capture it as text: https://dl.dropboxusercontent.com/u/...ined%2BOCR.jpg -------------------- Any thoughts on the authenticity of the other obscure reply here please? -- Terry, East Grinstead, UK |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro doesn't execute fully using shortcut | Excel Programming | |||
Workbook doesn't fully close - sorta | Excel Programming | |||
Why doesn't Excel "word wrap" always expand the cell fully? | Excel Discussion (Misc queries) | |||
Appending to a Cell doesn't keep format of existing content | Excel Programming | |||
Text not fully displayed when text direction changed | Excel Discussion (Misc queries) |