Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel: Format formula in cell as DATE
Message
From
22/09/2005 06:50:44
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
01051580
Message ID:
01051890
Views:
6
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