Date formatting
in [Programming]
|
From: rjagathe on 4 Mar 2010 11:15 I receive Excel data that contain "dates" from several branches.Some Branches have office 2000 and some have office 2003 and some more have office 2007.I use Office 2007.Some branches use dbf files also .I convert them into xls files.apart from this, dfferent branches use different date formats i.e., dd/mm/yyyy or mm/dd/yyyy or dd/mm/yy and so on.I want all the data in my PC to have dd/mm/yyyy format only.How to convert all formats into dd/mm/yyyy without doing nothing in winXP pro OS?is there any macro?
From: Bernard Liengme on 4 Mar 2010 13:12 Dates are stored in Excel as serial numbers; it is only the formatting that gives display in the US mm/dd/yyyy or the rest-of-world dd/mm/yyyy form. So all you need do is reformat the cells If you are importing from comma delimited file maybe the dates are actually text. Play around with Data| Text to Column; it has a feature to convert such text to dates best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "rjagathe" <rjagathe(a)gmail.com> wrote in message news:deec4eca-bc4d-4b7b-9242-64c1762872de(a)k18g2000prf.googlegroups.com... > I receive Excel data that contain "dates" from several > branches.Some Branches have office 2000 and some have office 2003 and > some more have office 2007.I use Office 2007.Some branches use dbf > files also .I convert them into xls files.apart from this, dfferent > branches use different date formats i.e., dd/mm/yyyy or mm/dd/yyyy or > dd/mm/yy and so on.I want all the data in my PC to have dd/mm/yyyy > format only.How to convert all formats into dd/mm/yyyy without doing > nothing in winXP pro OS?is there any macro?
|
Pages: 1 Prev: MS Excel 2003 - Advanced Features Add-In Next: Date format problem |