Thread: Date and time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default 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