| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONCATENATE And Date Format
I've always been doing formatting as =CONCATENATE(A4," - ",B4) where value is
'12/20/2006 on A4 and '12/31/2006 on B4 (12/20/2006 - 12/31/2006 printed format). Without the ' on the formula it becomes numerical (39071 - 39082). Is there a way to make it read (12/20/2006 - 12/31/2006) without the ' symbols? Thanks, Joseph Zuraski II |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the concatenate function to add a date into a sentenc | Excel Worksheet Functions | |||
| Include date in concatenate statement | Excel Discussion (Misc queries) | |||
| How do I concatenate two columns when one is in date format? | Excel Discussion (Misc queries) | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| concatenate text and date | Excel Discussion (Misc queries) | |||
Threaded Mode
