41913 |
41913 |
41913 |
41913 |
01/24/2014 |
01/24/2014 |
01/24/2014 |
01/19/2014 |
01/19/2014 |
01/19/2014 |
<tbody>
</tbody>
Hi there,
I'm importing data into Excel from an external source, in one column I have a series of dates. The problem is that Excel is importing these dates differently - some show up as the serial number so that I can get a 'UK' style dd/mm/yy date from them, others show up as text in the mm/dd/yy US format that I need to work with.
I have tried the text-to-columns trick and countless others but the fact that the data is in different formats is making it very difficult to work with! Can anyone please help?