Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel: Format formula in cell as DATE
Message
From
22/09/2005 07:04:08
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
22/09/2005 06:50:44
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Re: Excel: Format formula in cell as DATE
Miscellaneous
Thread ID:
01051580
Message ID:
01051892
Views:
7
Nevermind. I had bad data in the B column. Thanks!

>I get:
>
>
>#VALUE!
>
>
>in the cell as a result.
>
>
>>Column B formula:
>>=DATEVALUE((TRIM(LEFT(A2,5))))
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform