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

Yet if I edit B6, which still has Date format, it then overlaps.

https://www.dropbox.com/s/vnmrwrhh2p...ay-02.jpg?dl=0

Terry, East Grinstead, UK
Using Excel 365 under Windows 10.

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.
--
Windows10
Office 2016

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

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

Terry Pinnell 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

I think I may have developed a solution with this function.

=TEXT("20/1/18", "dddd dd mmmm yyy")

That displays 'Saturday 20 January 2018', using empty cells to the right
as required.

(Even better would be 'Saturday 20th January 2018' and I'll look into
that later, using the help Claus gave me last year on adding
'ordinals'.)

The snag is that in practice I'm not *manually* entering '20/1/18' but
doing it from my Macro Express Pro macro. But I should be able to
assemble it with MX Po in its three parts:
=TEXT("
20/1/18
", "dddd dd mmmm yyy")

and then paste that in its entirety into the worksheet.

--------------------

BTW, is that a Function or a Formula? I'm hazy about the difference.

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.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Terry Pinnell 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

I think I may have developed a solution with this function.

=TEXT("20/1/18", "dddd dd mmmm yyy")

That displays 'Saturday 20 January 2018', using empty cells to the right
as required.

(Even better would be 'Saturday 20th January 2018' and I'll look into
that later, using the help Claus gave me last year on adding
'ordinals'.)

The snag is that in practice I'm not *manually* entering '20/1/18' but
doing it from my Macro Express Pro macro. But I should be able to
assemble it with MX Po in its three parts:
=TEXT("
20/1/18
", "dddd dd mmmm yyy")

and then paste that in its entirety into the worksheet.

--------------------

BTW, is that a Function or a Formula? I'm hazy about the difference.

TEXT() is a function that you can use in a cell Formula.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

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