change date format.
Thanks Dave. It worked
--
"Dave F" wrote:
You need a custom format, not a function. Basically, you do the following:
select the cells which you want to apply this format to, right click, select
format cells, select custom format, and format your data DDMMYYYY
You may want to test this on a backup copy of your data to insure that it's
returning what you expect it to.
Dave
--
Brevity is the soul of wit.
"Betmck" wrote:
I have an excel 2003 file with 1500 dates in one column . The format is
10/31/2006 I have to import these dates into Microsoft Dynamics 9.0-fixed
assets. To import, the date format should be 10312006. Is there a function
that could strip the '/' out? could someone assist me with this task. Thanks
--
|