Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenate and Conditional Formatting | Excel Discussion (Misc queries) | |||
How can I concatenate a number and preserve the formatting? | Excel Worksheet Functions | |||
use formatting from source cell in CONCATENATE function | Excel Worksheet Functions | |||
use formatting from source cell in CONCATENATE function | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |