ClioSport.net
Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
-
When you purchase through links on our site, we may earn an affiliate commission. Read more here.
Excel again :)
- Thread starter Adam
- Start date
I'm guessing they are General format and are infact text?
In that case as a bodge I would try and use Replace, replace Sep with 09 and then replace spaces with /, then try and change the format again.
Pres Ctrl+F to open the Find box and tab to replace. someone might come up with a better solution though...
edit: tested this method and it worked in Excel 2010!
In that case as a bodge I would try and use Replace, replace Sep with 09 and then replace spaces with /, then try and change the format again.
Pres Ctrl+F to open the Find box and tab to replace. someone might come up with a better solution though...
edit: tested this method and it worked in Excel 2010!
Last edited:
The Boosh!
ClioSport Admin
Elise, Duster
I'd use text functions to arrange it as a UK date, C&P special values then format it as a date.
i.e to get 09/03/2012 into UK date it would be =mid(a1,4,2)&"/"&left(a1,2)&"/"&right(a1,4)
or you could do it all in one function...
=date(right(a1,4),left(a1,2),mid(a1,4,2))
It's difficult togive you a proper solution without seeing the data though, especially when linking to/from databases, as excel can do some strange things which need you to do a bit of fudging.
i.e to get 09/03/2012 into UK date it would be =mid(a1,4,2)&"/"&left(a1,2)&"/"&right(a1,4)
or you could do it all in one function...
=date(right(a1,4),left(a1,2),mid(a1,4,2))
It's difficult togive you a proper solution without seeing the data though, especially when linking to/from databases, as excel can do some strange things which need you to do a bit of fudging.
The Boosh!
ClioSport Admin
Elise, Duster
Lol, well done!
