Excel Query

I hav got in excel the date as 10609  (this is 1st june 2009), how do I convert this 10609 to 01/06/09??? I have many dates (over a thousand) so i cant do it manually.

Replies (2)

 

Hi Swapnil

=LEFT(C2,LEN(C2)-4)&"/"&MID(C2,LEN(C2)-3,2)&"/"&RIGHT(C2,2)

suppose the date is in cell "C2" then put following formula:-

Check it will work.... Subodh(Pune)

you can also try this formula

this will convert the text in Date format as per excel, which will be easy you use,

like if you want to write

10609

and you want to show it as

1-Jun-2009

this will remain in exact date format as per excel, which is easy to sort / filter later on if required.

suppose your 10609  is in A1

formula is

=DATEVALUE(LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,2))

it will be converted into Date Value

39995

now you can change date format to see date in any desired format.

Thanks

& Best Regards

Praveen

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details