Hi ive been importing some data into excel from access automatically. The datas problematic for me because it wont allow me to alter the format and I want to concatenate it aswell.
This is what my columns look like -
Column A is all
dd/mm/yyyy
Column B is all
hh:mm:ss
No matter what format I try and change to it wont alter, general, date to number etc etc. What id like to do though is to concatenate both the columns into one to allow me to sort chronologically.
Can anyone help? Thanks
RJ
Post up some sample data in a workbook, let is take a look at it. GO ADVANCED > paperclip icon.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It sounds as though the data is coming across as text.
If you highlight the column and use Data -> Text to Columns, then Next, Next, on step 3 use column data format "DMY" and finish.
The data should now be date and the formats you described should work.
Note: If this is a common import you may want to record a macro so you can just run it after the import.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks