Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "&" with a date
I feel like I should be able to figure this out as it seems like it would be simple, but I'm stumped. - I input a date (April 6, 2006) in cell A1. Cell A1 is formatted for Dates. - I then type this into cell D1: ="Sales total for "&A1 I want my result to read "Sales total for April 6, 2006" but instead I get "Sales total for 38813" It's putting the date in its numeric value. I've tried formatting D1 as Date, as Text, but nothing seems to work. Help? Thanks -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=530771 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "&" with a date
Try
="Sales total for "&TEXT(A1,"mmmm d, yyyy") -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "LACA" wrote in message ... I feel like I should be able to figure this out as it seems like it would be simple, but I'm stumped. - I input a date (April 6, 2006) in cell A1. Cell A1 is formatted for Dates. - I then type this into cell D1: ="Sales total for "&A1 I want my result to read "Sales total for April 6, 2006" but instead I get "Sales total for 38813" It's putting the date in its numeric value. I've tried formatting D1 as Date, as Text, but nothing seems to work. Help? Thanks -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=530771 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "&" with a date
="Sales total for " & text(a1,"dd/mm/yyyy") -- LACA Wrote: I feel like I should be able to figure this out as it seems like it would be simple, but I'm stumped. - I input a date (April 6, 2006) in cell A1. Cell A1 is formatted for Dates. - I then type this into cell D1: ="Sales total for "&A1 I want my result to read "Sales total for April 6, 2006" but instead I get "Sales total for 38813" It's putting the date in its numeric value. I've tried formatting D1 as Date, as Text, but nothing seems to work. Help? Thanks -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=530771 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "&" with a date
Thank you both! -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=530771 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |