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



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

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries