Đã hoàn thành

Formatting Excel Cells


I am currently exporting my entire inventory list into a CSV file. I am having some issues exporting my SKU codes as they are in the format of XX-XX-XX (for example: 21-4-1). Once this is exported into CSV – it won’t allow me to change it back to general text without dismantling the figures. I’ve tried “More Number Formats” > Custom > dd-mm-yy.

However, this format won’t apply for all the SKU codes.

Can someone please show me how to change the SKU codes back to just general format in numerals XX-XX-XX or whichever format applies (i.e. X-X-X or XX-X-XX) ?

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Visual Basic

Xem nhiều hơn: macro excel cells, copy excel cells web pages, vba excel cut paste excel cells, how to format cells in excel 2010, custom format cells in excel, conditional formatting cells in excel, format cells in excel shortcut, what is formatting in excel definition, excel format formula, how to format cells in excel 2016, cell formatting in excel 2007, formatting excel php mysql, excel vba freelancer, excel project freelancer, excel macros freelancer, vb6 conditional formatting excel, visual basic pasting data excel cells, formatting excel documents, excel templates freelancer, copy excel cells using macro

Về Bên Thuê:
( 5 nhận xét ) Glendenning, Australia

ID dự án: #20439358

Được trao cho:


You are looking at a basic formatting issue (Excel can be such a pain sometimes, right?) I am very handy with excel and I would be very happy to assist. I am eager to start building positive performance reviews, and so Thêm

$10 AUD trong 1 ngày
(0 Đánh Giá)

54 freelancer đang chào giá trung bình $21 cho công việc này


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Thêm

$35 AUD trong 1 ngày
(716 Nhận xét)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Thêm

$35 AUD trong 1 ngày
(339 Nhận xét)

Hello! i can help you right now. I can show you how to change the SKU codes dormat. You will not be dissapointed, I have a big 32% rehire rate. Thank you!

$30 AUD trong 1 ngày
(261 Nhận xét)

Hello sir, i know why it's showing like that and i can fix it within 5 min. plz msg me so we can more talk and start work right now,thank you.....

$20 AUD trong 1 ngày
(560 Nhận xét)

Hello, i'm professional data entry expert with 6 years of experience, i have done 300+ projects successfully with 100% accuracy. Can you please message me regarding this project so that we can discuss more? Thank you!

$30 AUD trong 1 ngày
(252 Nhận xét)

I have read your project details and i think i am the right person which you are looking for.i have done many same project, you can check my [login to view URL] is my guarantee,if you want free samples then ping me back. Thêm

$30 AUD trong 1 ngày
(354 Nhận xét)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 AUD trong 1 ngày
(304 Nhận xét)

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many Thêm

$10 AUD trong 1 ngày
(239 Nhận xét)

Hi There, Happy to help you on this task. Would you mind sharing the csv so I can do the task first and if you are happy with it, you can offer me the job later. I am an expert in advanced excel features and you may re Thêm

$30 AUD trong 1 ngày
(193 Nhận xét)

Dear, I can start now to make SKU codes in right format. I don't have any work for this time, so i can spend all my time. I have completed some excel project before, feel free to review my profile. Please give me t Thêm

$19 AUD trong 1 ngày
(285 Nhận xét)

Sir, A short brief :- Is that your project? Could you select me as your employee? Thank you and waiting for your reply.

$30 AUD trong 1 ngày
(124 Nhận xét)

Hi, I have read your project description and i have understood about your project. I can change date format within short time. If you consider me for your projects, I will provide best quality service. I look forwar Thêm

$30 AUD trong 1 ngày
(60 Nhận xét)

Hi, Greetings. Have you tried with changing the format to text, not number. If you kindly share the csv file, i could come back with result shortly. Thank you.

$20 AUD trong 7 ngày
(190 Nhận xét)

Hi, Please provide me file so i can fix it and send it back to you right now. I am looking forward for your early reply. Regards, Teena

$10 AUD trong 1 ngày
(139 Nhận xét)

I can do your project in less than 1 hour (Draft) according to your description (Formatting Excel Cells) with full delivery and without error. I would also complete your project with the highest precision and quality. Thêm

$32 AUD trong 2 ngày
(116 Nhận xét)

Hi There, I have read your details & I think I am the perfect one for your job. I have completed several project like this. Quality & accuracy is my commitment. I am ready to show you free sample. Please message me b Thêm

$15 AUD trong 1 ngày
(71 Nhận xét)

Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. I will complete this task with your timeline and [login to view URL] give me a chance to serve Thêm

$20 AUD trong 1 ngày
(87 Nhận xét)

Hello. Nice to meet you. I have good skills in "Visual Basic, Data Processing, Data Entry, Excel" and i 'm very interest to your project. I have checked description of your project "Formatting Excel Cells" carefully an Thêm

$30 AUD trong 1 ngày
(11 Nhận xét)

Hi, I am fully capable of this job. I am professional in PHP/WordPress/HTML/CSS and working as a freelancer for more than 8 years. I know how to handle this type to work with in time. If you are looking for best servic Thêm

$20 AUD trong 7 ngày
(2 Nhận xét)

Hi There, I can help you to fixed it your issue. I have read and understood your problem. I have many experience using excel over 10 years. This is just simple task. thanks. regards.

$20 AUD trong 1 ngày
(6 Nhận xét)