Excel data format issue (convert?)

June 8, 2011 at 18:37:03
Specs: Windows 7 64x
I have data arround 10.000 columms and they have different date format as I need.

They have

20101205 230100
20101205 230200

they are general format, bud when I change it to date format I get only ####


I need format like this:

1.1.2011 0:00
1.1.2011 0:08

Can me somebody help how to make it ?

Thx you very much in forward


See More: Excel data format issue (convert?)

Report •

#1
June 8, 2011 at 20:14:30
This should be in the Office Forum here: http://www.computing.net/forum/offi...

Report •

#2
June 8, 2011 at 20:56:03
The ##### will show up when your columns are too narrow to show the entire sequence, try widening the column(s) in question. post in the Office forum.

You have to be a little bit crazy to keep you from going insane.


Report •

#3
June 9, 2011 at 10:59:22
sry nope thats not the issue

here is example, can anybody help ?

thx

http://uploading.com/files/695fe789...


Report •
Related Solutions


Ask Question