May 28th, 2010, 08:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|
Date inconsistent help please :)
Thank you both - I'll find out and give these a try
--
Thank you in advance!!!!
"Fred Smith" wrote:
Something like this:
=--if(len(a1)=4,"1/1/"&a1,if(len(a1)8,"1/"&a1,a1)
Regards,
Fred
"daisy" wrote in message
...
Is it possible to clean up a date field where someone was keeping an excel
sheet but the date field is a mess
For example he has
1998
2/2005
1/1/2010
We need all dates to be mm/dd/yyyy?
Is there a formula or update I could run against this so he's not going
thru
3000 rows of data?
Thank you!
--
Thank you in advance!!!!
.
|