Format and Display of Date (d)

Pete Pierron

New Member
Joined
Dec 12, 2005
Messages
4
Am attempting to put a date into a single wide column where cell is a merged cell (one over other) with word wrap on. Sheet width is limited and need day of month displayed in single wide cell.
This is part of a Gnatt Chart.

Any help is appreciated.

Pete
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Welcome to the board.

I do not understand what you are trying to do. With today's date as an example, what result are you trying to produce?
 

Pete Pierron

New Member
Joined
Dec 12, 2005
Messages
4
Using today's date as a start, I will have a 4 month period of daily dates running horizontally across page. In order to show all dates of the months I would like to display them in a vertical merged cell. They need to be real dates not just a general number. I can get this to work if I use numbers, but not as a date. By vertical merged cell I mean two cells in different rows directly above one another. This cell I also formated "wrap text" with the thought that this would put the two digits one over the other in the merged cell. I do not have sufficient room/width in the spreadsheet to display each date with its numbers displayed side by side, like we normally expect to see a date displayed.

I will not be displaying Month or Year, just the date (day of month) such as 13 14 15, etc. Created a custom date of (d) to display only the date.
 

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
So, if I understand correctly, you are wish to consolidate each day into it's particular month when you merge?

Why not just custom format the date

Format>Cells>Custom

"mmmm" would show January, February..etc

"mm/yy" would show 01/05, 02/05 etc..
 

farnuckl

Board Regular
Joined
Dec 16, 2003
Messages
127

ADVERTISEMENT

Hello, in my testing, the only way I found to get the appearance you desire is to input the double-digit dates as just numbers (e.g. 10, 11). When Excel looks at them as dates, it doesn't seem to allow word wrapping.

-farnuckl

edit: You could also try rotating the text 90 degrees, that would allow the same width and let you keep the formating and date info the same. You just need to play with the alignment to make it look alright.
 

Pete Pierron

New Member
Joined
Dec 12, 2005
Messages
4
Thanks for the replies.
As Farnuckl has noted, word wrap does not seem to function on a real date; works fine on general numbers.
The Gnatt Chart needs to display months worth of dates in horizontal fashion therefore not providing a lot of space if displaying more than one character wide.
Still looking for help, if anyone can come up with a fix.
 

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
Have you tried formatting the cell and doing the 90 degree rotation? That seems to be the obvious choice...although I had guess you already gave that a shot.
 

Pete Pierron

New Member
Joined
Dec 12, 2005
Messages
4
Thanks for the suggestions!
With the brainstorming you did and more stewing on my part, I found a workaround.
I have inserted a row with the full date information that the Gnatt Chart needs and then changed the font color to blank/white. Will have to protect it, but that is easy.
Now I can have the date format I need for the conditional formating formula and the visible display that makes it useable.

Again, THANKS!

Pete
 

Watch MrExcel Video

Forum statistics

Threads
1,118,290
Messages
5,571,327
Members
412,382
Latest member
Langtn02
Top