excel
This query is : Resolved
10 March 2011
Can u convert DD/MM/YYYY IN TO DD/MM/YY IN ms eXCEL i AM USEING WINDOWS xp
10 March 2011
Type date as 10/03/2011 in any cell
Go to
Format>Cell>Category>Custom
In opposite side of custom you see the date type as dd/mm/yyyy make it as dd/mm/yy
10/03/2011 converted as 10/03/11
Go to
Format>Cell>Category>Custom
In opposite side of custom you see the date type as dd/mm/yyyy make it as dd/mm/yy
10/03/2011 converted as 10/03/11
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
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Price inclusive or exclusive of GST while made entry in P& L Account
- Dep. as per companies act
- Minimum tax payable to file Updated return
- Tds on commission charges
- Applicability of GST on Salary Reimbursement Component
- TDS on purchase of under construction property from a reseller
- New GST registration for new place of business.
- Need Professional Opinion AY 2012-13 Old Demand
- Salary from Qatar in Dollars in India
- SALARY CAN BE CAPITALIZE
- GST Intimation due to Government took possession of Business Premises under PPE Act
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
Quick Links
ARTICLESHIP
18 September 2026
Industrial Trainee
Twenty Point Nine Five Ventures Private Limited
Noida
CA Inter
View Details
ARTICLESHIP
04 September 2026
Accounts Executive
Hema Yashwanth & Associates
Chennai
B.Com
View Details
CCI
Pro
CAclubindia
