convert to date

[nasser]

hi all , first I'm trying to convert an unknown cell format , to date (H:H) but i have to double click (edit then leave) each cell to convert to date...
and second, I used the ( &) sing to get 2 cells together , it working , but when i make sort it not sorting correct , so i think it needs to be converted to some format too
thank you

[NBVC]

To convert the column to true dates, select the column and go to Data|Text to Columns... then skip to the third window and select Date in the Column Data Format area and select DMY from the adjacent drop down menu.

Click Finish.

Now I am not sure what exactly you mean with the sort question... can you elaborate?

[VBA Noob]

Select the column > Text to column > at wizard stage 3 select date

What order are you expecting in the sort

VBA Noob

[GuruWannaB]

**Removed...

[nasser]

Select the column > Text to column > at wizard stage 3 select date

What order are you expecting in the sort

VBA Noob

Thank u the date tips was so right and worked with me , about the sorting NOT to be like
11305/60
11306/10
11306/11
11306/12
11306/13
11306/14
11306/15
11306/16
11306/17
11306/18
11306/19
11306/20
11306/21
11306/9
so i think that 11306/9 ( the last entry have to be in the top of 11306/10

[NBVC]

Change the Format in Column B to Numbers: Select column B and go to Data|Text to Columns and just click Finish.

Then Sort by Column D and then by Column B within same Sort

[nasser]

Change the Format in Column B to Numbers: Select column B and go to Data|Text to Columns and just click Finish.

Then Sort by Column D and then by Column B within same Sort

thanks man that succefuly help and solved it
have a great time thanks again

[martindwilson]

or use
=D2&"/"&CHOOSE(LEN(B2),"000","00","0","")&B2
which also gets rid of column E

[NBVC]

Or if you want that format and get rid of column E...then

=D1&"/"&TEXT(B1,"0000")

or

=D1&TEXT(B1,"\/0000")

then sort by this new column E.

should work.

[nasser]

for the last 2 replies i recieve this error in the attachment

[NBVC]

See attached...

Can't see in your .jpg if you actually used single or double quotes....

[nasser]

See attached...

Can't see in your .jpg if you actually used single or double quotes....

i took it as a copy and paste in the formula bar it not worked so i made it single quotes but also not worked , but i c it worked in the file that u sent to me
thank u so much

[nasser]

thank u all guys for ur help .. best wishes and Good night

[NBVC]

I bet it is the version your on

Try instead:

=D1&"/"&TEXT(B1;"0000")

Some versions of Excel you need ; to separate arguments, while other more popular versions need the comma.

[nasser]

I bet it is the version your on

Try instead:

=D1&"/"&TEXT(B1;"0000")

Some versions of Excel you need ; to separate arguments, while other more popular versions need the comma.

yes NBVC .. the Comma was the problem and it working so well now , thanks alot for ur concern