Prev: Compare worksheet data
Next: Double If Statement help
From: Katerinia on 31 Mar 2010 13:49
=text(a1,"yyyy/mm/dd")
Did the trick! IT was happy when they got the file! YAY. Thanks for your
help!

"Dave Peterson" wrote:

> 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
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Compare worksheet data
Next: Double If Statement help