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:05:45
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
22/09/2005 07:04:08
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:
01051893
Views:
10
Here are the stars I would like to be able to give you: ***

>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