In csv excel represent one column value wrong way. I need correct format

I have attached one sample csv file. Look for coloumn category_ids. It shows value like this "404,640,944,367"

while actually it should show "4046,4094,4367". This column represent category id which is 4 digit value. for any product it may be one category id or more than one also possible. here 3 category_ids assigned

I tried many different way to format it but no luck. It works perfect in open office but i need solution in ms excel.

Does anyone has solution for this? If any one has solution they can submit screenshot of working and i will award project to only him. This is very small task for excel expert.



Квалификация: Excel

Показать больше mysql import csv excel, vba excel delete column, macro convert csv excel, why does my exported csv data get converted to weird formats?, how to keep text format in csv, how do i keep a long number format on a csv file?, csv file loses formatting, how to keep number format in csv file, open csv file in excel without formatting, how to force excel to open csv files with data arranged in columns, csv files lose formatting after save, search data csv excel vba, howto export data csv excel format php mysql, excel convert column rows, csv excel automatically, excel convert column multiple columns, excel vba increment value, microsoft excel column value formula column, excel macro cut paste based column value, excel assign rank value based column values

О работодателе:
( 11 отзыв(-а, -ов) ) Ahmedabad, India

ID проекта: #19656068



Hello there, I am an Excel expert. Please contact me I will support you. Just some trick in excel. Thank you.

$15 USD за 7 дней(-я)
(84 отзывов(-а))

Hello Sunny, I have solved your problem. Kindly contact me via chat so that I can provide you the screenshot for the sample I have completed. Thank you, Kind Regards, Snigdha Paul

$10 USD за 1 день
(37 отзывов(-а))

20 фрилансеров(-а) в среднем готовы выполнить эту работу за $21


I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for this project. Please send me a message and we can discuss further.

$20 USD за 1 день
(46 отзывов(-а))

Hi Sunny, I got the solution please reply to this message for a screenshot (sorry can't upload with you replying.) Imran

$30 USD за 1 день
(39 отзывов(-а))

Hi Good Day! A serious freelancer here. I've done a lot of job like this before and I can help you with this project. Please consider my bid. I already checked your file and trying to do a solution using formula. Больше

$20 USD за 1 день
(24 отзывов(-а))

Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of DASHBOARDS, FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Больше

$25 USD за 7 дней(-я)
(21 отзывов(-а))

Hi Dear Sir, after reading the project description, Sir I am able to write proposal for this project. Sir I am expert in all those skills which is mentioned here, and all those which is require for this project. Sir I Больше

$10 USD за 1 день
(35 отзывов(-а))

I have read the job details and screenshot is ready and you can contact me anytime via chat. And You can send me the full file.

$15 USD за 1 день
(15 отзывов(-а))

HI! I think, I have found the solution for your problems, please chat and i'll show you the screenshot

$15 USD за 0 дней(-я)
(6 отзывов(-а))

Dear Hiring Manager! I have reviewed your requirements for your preconceived project. I'm interested in your project. I have 3 Years experience in Data Entry, Data scraping, Lead generation & Web research. I'm availa Больше

$20 USD за 3 дней(-я)
(3 отзывов(-а))

Hello there, After carefully reviewing the requirements of the Project, I believe that my strong experience and dedication make me a suitable match for this. I have vast experience in Excel Data Entry with more than 1 Больше

$20 USD за 2 дней(-я)
(2 отзывов(-а))

I am very good at arranging the data in a organised format in excel. I know many formulas and the shortcuts that help me to get it done in minutes or a few hours depending on the type of work

$15 USD за 1 день
(0 отзывов(-а))

Hello Dear Client, I read through the job details of your project and I am absolutely sure that I can do this project very well, I have more than 5 years of experience in it. I Provide - - 24x7 Services to My Cl Больше

$30 USD за 1 день
(1 отзыв)

I can do this since I have so much spare time

$25 USD за 1 день
(0 отзывов(-а))

Hi! Hope you are fine. It's Mudassar here. You can trust me i'll deliver 100% accuracy. Can you give me a chance to serve you? Kindly consider me. Best wishes, Mudassar Relevant Skills and Experience I am well in Больше

$25 USD за 1 день
(0 отзывов(-а))
$25 USD за 1 день
(0 отзывов(-а))

Hello, I am ari, I've carefully gone through your project brief and I confidence that I have the expertise to work on your project. I will be very happy to have a chance for an interview with you.I'm always commi Больше

$25 USD за 1 день
(0 отзывов(-а))

i have done it already in excel. dont know how to attach file i will do it for you in 5 mins just let me know when to start

$15 USD за 1 день
(0 отзывов(-а))

I will resolve the issue and will provide you the exact in ms excel format

$25 USD за 1 день
(0 отзывов(-а))

data entry I am Data Entry Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy . If you are looking for data entry or search work, I am th Больше

$30 USD за 2 дней(-я)
(0 отзывов(-а))