Share via

Data changes after splitting

Anonymous
2020-08-24T14:59:16+00:00

When I split the data, some of the numbers from what I noticed, where switch to dates but, when I change the cell formatting of that column to general it doesn't revert back to the original number. instead it turns into something like 48342

Heres an example: 

Below is what I expect 1003-5 to look like after splitting 1 and 0 with text to column

|1|0|03-5| 

Instead I get

|1|0|5-Mar|

Then when I change the cell format to general I get

|1|0|43895|

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Andreas Killer 144.1K Reputation points Volunteer Moderator
2020-08-24T18:57:33+00:00

I tried text as well but the issue still persists

Have a look:

https://youtu.be/MCSTciirM1E

Was this answer helpful?

0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Anonymous
    2020-08-24T19:56:15+00:00

    For me for some reason it keeps repeatedly crashing if I choose text right after i press finish. 

    Im assuming it might be the amount of records Im working with (68,000)

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-08-24T19:14:15+00:00

    Oh okay, I didnt we had to choose each individual column. Thanks!

    Was this answer helpful?

    0 comments No comments