'excel csv not displaying string column correctly

I have a csv file below:

RTC ID,RTC Type,RTC URL,ADS URL,RTC Unreachable Children,# RTC Unreachable Children
199420,story,https:/xxx890,httxxxxxxxxx9420,"199701,199858,199608",3

If I preview it in vscode, it looks fine, but when opened in excel, the "RTC Unreachable Children" column is displaying incorrectly.

I've tried clicking to highlight the entire column and changing the text formatting in excel but string / general / dont work, is there any way I can tell excel to display the commas separating each number inside the quotation marks?

excel string csv

Solution 1:^[1]

This worked, i had to go through these steps:

open new excel
go to 'data' tab, import from csv
choose csv
choose 'transform data' before importing
go to the column and select it
go to data type and set as 'text'
import csv
save as .xlsx or something else (dont save as .csv) done

Thank you @POVR2 and @ScottCraner in the comments

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	POVR2

'excel csv not displaying string column correctly

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]