date issues in Excel

View previous topic View next topic Go down

date issues in Excel

Post by gridley1982 on 26th July 2016, 11:35 pm

Hello

I have to deal with various data reports from out work system, when the data is exported the date shows as attached.

IT say they cant/wont change how the data is extracted so im left with an issue.

I can change the cells that read 29032007 etc using the text to columns option but the cells that read 3052007 (auto dropped the 0) are causing me problems.

I have changed the format to a custom 00000000 string but when I then run the text to columns option the cells that now start with a 0 do nothing and the cells that previously worked change to a completely different string of numbers that isnt in any date format.

Can anyone help?



gridley1982
Novice
Novice

Posts Posts : 6
Joined Joined : 2015-10-29
OS OS : 10
Points Points : 4136
# Likes # Likes : 0

View user profile

Back to top Go down

Re: date issues in Excel

Post by Superdave on 27th July 2016, 10:15 pm

The only way I can help you is to give you a link from my home forum here. If you can't find the answer you could post a question in the software forum of this site. There are many experienced persons that may be able to help you.

Superdave
Captain
Captain

Posts Posts : 4202
Joined Joined : 2010-02-01
Gender Gender : Male
OS OS : Windows 8.1 and a dual-boot with XP Home SP3
Protection Protection : MSE, Windows Defender, Windows firewall
Points Points : 83211
# Likes # Likes : 0

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum