Articles Comments

Free Excel Dashboards » Dashboard, Excel Dashboard, Excel Dashboard Software, IT » How to Convert Unusual Date Text in Excel

How to Convert Unusual Date Text in Excel

When you import data into Excel, dates often arrive in formats that Excel doesn’t recognize. This is particularly true if your data comes from another country. This figure shows an extreme example. Column A contains a variety of date formats, and column B shows how this formula… B1:    =DATEVALUE(A1) …fails to convert them. The common [...]

For more information visit How to Convert Unusual Date Text in Excel

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT

Comments are closed.