danlu
02-08-2008, 07:21 AM
Hi,
I have a column (for ex column B) with dates (actually it doesn't matter if the cells have date format or something else the important thing is that it is displayed with a date look, in this case for ex 2007-01-10 ( that is the 10th of January 2007)
To these dates I want to add ' on both sides of the date so it looks like '2007-01-10', to achieve this I have tried to use the concatenate like this:
=concatenate ("'";B2;"'")
But Excel always convert my date value into a number format so the result looks something like this: '39092'
Which causes me trobles since I want to copy this data into another program (that doesn't have anything to do with Excel) where I want to display all dates surounded with ' on both sides.
Any suggestions are welcome
I have a column (for ex column B) with dates (actually it doesn't matter if the cells have date format or something else the important thing is that it is displayed with a date look, in this case for ex 2007-01-10 ( that is the 10th of January 2007)
To these dates I want to add ' on both sides of the date so it looks like '2007-01-10', to achieve this I have tried to use the concatenate like this:
=concatenate ("'";B2;"'")
But Excel always convert my date value into a number format so the result looks something like this: '39092'
Which causes me trobles since I want to copy this data into another program (that doesn't have anything to do with Excel) where I want to display all dates surounded with ' on both sides.
Any suggestions are welcome