#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default EXCEL CELL MERGE

I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default EXCEL CELL MERGE

Patricia wrote:
I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!



You need the TEXT() worksheet function.

Something like this...

=H3&" "&TEXT(G3,"dddd, mmmm dd, yyyy")&" "&H4
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default EXCEL CELL MERGE

=A1&" "&B1&" "&TEXT(C1," mmm dd yyyy")

Assumes C1 has a valid date.


Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 12:33:02 -0700, Patricia
wrote:

I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
Default EXCEL CELL MERGE

"Patricia" wrote:

I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!


Thank you for the answers! You made me look like a whiz kid to my boss!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help on excel merge cell Sandip Patel Excel Discussion (Misc queries) 4 October 15th 07 03:51 PM
Mail merge an excel cell that is preceeded by an apostrophe? Rubicon needs help Excel Discussion (Misc queries) 1 August 23rd 07 07:50 PM
Excel should let me use the merge and center with unprotected cell Dennis Cantellops Excel Discussion (Misc queries) 0 August 26th 06 03:46 AM
Excel should merge cells without removing content of any cell Rumpa Biswas Excel Discussion (Misc queries) 14 January 1st 06 01:32 AM
Excel cell filler for word merge document Shawna Excel Discussion (Misc queries) 1 October 28th 05 08:10 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"