reformat dates to yyyy/mm/dd
in [General]
|
Prev: Compare worksheet data
Next: Double If Statement help
From: Katerinia on 31 Mar 2010 10:44 I have a worksheet with dates of mm/dd/yyyy I need to reformat them now to be yyyy/mm/dd Whats the formula for that?
From: Dave Peterson on 31 Mar 2010 10:50 If the values are really dates, you could just select the range and change the format to what you want. Katerinia wrote: > > I have a worksheet with dates of mm/dd/yyyy > > I need to reformat them now to be yyyy/mm/dd > > Whats the formula for that? -- Dave Peterson
From: FSt1 on 31 Mar 2010 10:57 hi formulas cannot return formats only values. right click the cell in question and apply a custom format.... in the type box of the custom catagory enter.... yyyy/mm/dd regards FSt1 "Katerinia" wrote: > I have a worksheet with dates of mm/dd/yyyy > > I need to reformat them now to be yyyy/mm/dd > > Whats the formula for that?
From: Katerinia on 31 Mar 2010 11:53 My concern is the data being uploaded into a database, even though the format looks like yyyy/mm/dd, the cell value is still mm/dd/yyyy. Will it read the data the way IT says it should be (yyyy/mm/dd) "Dave Peterson" wrote: > If the values are really dates, you could just select the range and change the > format to what you want. > > > Katerinia wrote: > > > > I have a worksheet with dates of mm/dd/yyyy > > > > I need to reformat them now to be yyyy/mm/dd > > > > Whats the formula for that? > > -- > > Dave Peterson > . >
From: Dave Peterson on 31 Mar 2010 12:47
It depends on the process that you use to upload them into your database. If you save a Text file (like .txt, .prn, or .csv), try reformatting, doing the SaveAs and open the text file in Notepad to verify. If your importing procedure reads the excel file, I would think that it would be better to make sure that it knows how to read dates--and handles them correctly itself. If the importing procedure reads the field as text (while in excel), you could use a helper column with a formula like: =text(a1,"yyyy/mm/dd") and drag down Copy|paste special|values and delete???? the original field. But that won't work if the original data isn't a real date. Katerinia wrote: > > My concern is the data being uploaded into a database, even though the format > looks like yyyy/mm/dd, the cell value is still mm/dd/yyyy. Will it read the > data the way IT says it should be (yyyy/mm/dd) > > "Dave Peterson" wrote: > > > If the values are really dates, you could just select the range and change the > > format to what you want. > > > > > > Katerinia wrote: > > > > > > I have a worksheet with dates of mm/dd/yyyy > > > > > > I need to reformat them now to be yyyy/mm/dd > > > > > > Whats the formula for that? > > > > -- > > > > Dave Peterson > > . > > -- Dave Peterson |