Easy Office
LCI Learning

excel

This query is : Resolved 
Profile Image

Profile Image

(Querist)
10 March 2011 Can u convert DD/MM/YYYY IN TO DD/MM/YY IN ms eXCEL i AM USEING WINDOWS xp
Profile Image

Rajan Kapoor

Profile Image

Rajan Kapoor (Expert)
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

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

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries



Live Budget News and Updates

Trending Online Classes

view all classess
Let's Talk Money: You've Worked Hard for It, Now Make It Work for You
Click here for more bestsellers


Answer Query



Quick Links