How to show full contents of cell?

terrypin

New Member
Joined
Dec 3, 2016
Messages
25
Why can I not see the full contents of B2, '03/12/2016 11 :19', extending into the next empty column, just as in the row above?
I don't want to widen col B.

Excel365-Column-01.jpg


--
Terry, East Grinstead, UK
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

BQardi

Active Member
Joined
Aug 30, 2016
Messages
483
As far as I know the "extending" of values in a cell only works with text!
So a date won't extend.
Numbers won't extend.
So on...
 
Last edited:

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
terrypin,

Welcome to the MrExcel forum.

BQardi is correct.

Try adjusting column B's width to display the data correctly in cell B2, or, change the font size in cell B2, or try both suggestions.
 
Last edited:

BQardi

Active Member
Joined
Aug 30, 2016
Messages
483
Yeah. Or you could merge cells, allthough I usually don't recommend this, but in some circumstances there is just no other option.

If it is layout you are worried about, maybe left align all cells in column B and expand width of column B to fit values...

Just some thoughts...
 

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
without merge you could centre across the two cells or maybe make it text

=TEXT(NOW(),"dd/mm/yyyy hh:mm")
 
Last edited:

terrypin

New Member
Joined
Dec 3, 2016
Messages
25
Thanks all, appreciate the fast responses.

Note that I explicitly ruled out widening col B.

I had been assuming that cell B2 would be treated identically to B1, as text. Both have a General format. And I also tried Text format in vain.

However, prompted by your replies, I now realise that Excel must be insisting on treating it as a date. So I'll simply prefix it with a single quote character.

Terry, UK
 

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
terrypin,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.
 

Forum statistics

Threads
1,171,535
Messages
5,876,072
Members
433,172
Latest member
Mohamed Hamada 22

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top