View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chuck B Chuck B is offline
external usenet poster
 
Posts: 2
Default CONCATENATE Date formatting

The intent of the function below is to create a string like so in a cell:
"Week Of: 01/24/08"

= CONCATENATE("Week Of: ", Mon!A1)

Instead, it's giving me this: "Week Of: 39268"

I believe 39268 is the integer value that Excel uses to represent dates
internally.

I've tried a few different things to make the date come out formatted the
way I want but so far nothing has worked. This is problem some simple thing
but I don't work with Excel formulas much.

Can someone tell me what I'm doing wrong?

Thanks.