I'm trying to convert a column of data in date format *m/d/yyyy to a text
format without converting to serial numbers. Ie: I want to retain the
mm/dd/yyyy format. Is there a way to do this?
I'm trying to convert a column of data in date format *m/d/yyyy to a text
format without converting to serial numbers. Ie: I want to retain the
mm/dd/yyyy format. Is there a way to do this?
=TEXT(A1,"MM/DD"/YYYY")
"sprlarry" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to convert a column of data in date format *m/d/yyyy to a text
> format without converting to serial numbers. Ie: I want to retain the
> mm/dd/yyyy format. Is there a way to do this?
That places a formula in the field. I actually need a value with the
mm/dd/yyyy format to load to a different system. Any suggestions?
"N Harkawat" wrote:
> =TEXT(A1,"MM/DD"/YYYY")
>
> "sprlarry" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying to convert a column of data in date format *m/d/yyyy to a text
> > format without converting to serial numbers. Ie: I want to retain the
> > mm/dd/yyyy format. Is there a way to do this?
>
>
>
"sprlarry" <[email protected]>ha scritto nel messaggio
[email protected]
> That places a formula in the field. I actually need a value with the
> mm/dd/yyyy format to load to a different system. Any suggestions?
Once you have done as suggested, you have to Copy & Paste Special, Values...
--
Hoping to be helpful...
Regards
Franz Verga
----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks