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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

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

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows

ADVERTISEMENT

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,174
Members
417,130
Latest member
Darion2021

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