Date and time
Hi all,
I've got a worksheet containing multiple columns with data. One of the rows
is a combination of yyyy/mm/dd/hr/mn/sd (20080908081442) except form '/'.
Excel also indicates the data in this column with an error indicator. However
when I use text to columns or format cells the desired result, creating a
clear view of the date and time (2008/09/08 08:14:42), is not managed. Anyone
has an idea how to solve this?!
Thnx
|