Reformat a date imported from another program
Another one:
=--TEXT(LEFT(A1,8),"0000\-00\-00")
And format the cell as a date.
=text() will return a string. The -- stuff converts that text date to a real
number. Reformatting makes it look pretty.
Heather wrote:
I export data from another program into Excel. This data contains dates
which are formatted like this: yyyymmdd000000. When the data is imported
into Excel, the date shows in the cell like #.#####E+13. The formula bar
shows the date as it appears in the original program (yyyymmdd000000). How
can this date format be converted to mm/dd/yyyy or another date format which
excludes extraneous zeros?
--
Dave Peterson
|