banner_ad

Ms excel query

This query is : Resolved 
Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
08 November 2014 In a cell ythe date was keyedin as 19500803 - how to convert this date to 03-08-1950 please answer me
Profile Image

Ganeshbabu K

Profile Image

Ganeshbabu K (Expert)
08 November 2014 1)Right click

2)click on format

3)under category choose date

4)alter the format as u need and click okay
Profile Image

Damodaran

Profile Image

Damodaran (Expert)
08 November 2014 Try this; =right(Cell ref,2)&"-"&mid(cell ref,5,2)&"-"&left(cell ref,4)
Profile Image

@VaibhavJ

Profile Image

@VaibhavJ (Expert)
09 November 2014 Hi

Select whole range, then select data text to column option. Press next and then select date and ymd option and press ok.

Thanks
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
08 May 2026
CHARTERED ACCOUNTANT

SHAH LADHA AND ASSOCIATE

Ahmedabad

CA

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
19 May 2026
Fundraising Expert

MentorsWorld Ventures Private Limited

Ahmedabad

Others

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details