Ms excel query
This query is : Resolved
Querist : Anonymous
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
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
2)click on format
3)under category choose date
4)alter the format as u need and click okay
08 November 2014
Try this; =right(Cell ref,2)&"-"&mid(cell ref,5,2)&"-"&left(cell ref,4)
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
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- REGARDING GST ON COMMERICIAL PROPERTY
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- TDS U/S. 194NF
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- Applicable TDS rate for sale of property in Nov 2024
- Donation Receipt u/s 80G
- TDS deduction (debit notes)
- Can a partnership firm become partner in a LLP ?
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- TDS on purchase of value vouchers for employees ?
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
Trending Online Classes
CAclubindia
