 Search the Knowledgebase |
 Browse by Category |
|
|
|
| How do I read Excel data formatted as a date 19950102? |
| User Opinions |
|
No users have voted.
|
|
Thank you for rating this answer.
|
Surfer does not have the ability to read different date formats, but you may be able to convert your date to a numeric value corresponding to the date format in Excel. If the date is in any format in cell B1, add a formula to cell C1 to convert the number to text, then convert the text to a value.
= VALUE(TEXT(B1,"yyyymmdd"))
Please consult your Excel documentation for more information about functions in Excel.
|
| Visitor Comments |
|
No visitor comments posted. Post a comment
|
| Attachments |
|
No attachments were found.
|
Print this page
Email this page
Post a comment