View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carlo carlo is offline
external usenet poster
 
Posts: 367
Default Concatenate Question

Hi Heather

why don't you format the field to show the Name of the Day as well?
Custom format would be: dddd mmmm d, yyyy
or (if you want 3 letter months) dddd mmm d, yyyy

i hope i understood you right

Carlo

On Jan 16, 1:37*pm, Learningfast
wrote:
HI
My data is two values
Day * * * * * * Monday
Date * * * * * * * * *May 8, 2008

The new result it
Concatenate #1 *Monday34567 (the result has no space and there is a number
instead of the date).

Question: *How do I program a space between the two and
Question: *How do I format the date as text so it looks like a date?

Thanks!
Heather