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) ?

Evner: Excel, Dataindførsel, Databehandling, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 7 bedømmelser ) Glendenning, Australia

Projekt ID: #20439358

Tildelt til:


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 Flere

$10 AUD på 1 dag
(1 bedømmelse)

53 freelancere byder i gennemsnit $21 på dette job


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 Flere

$35 AUD på 1 dag
(719 bedømmelser)

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. Flere

$35 AUD på 1 dag
(339 bedømmelser)

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 på 1 dag
(267 bedømmelser)

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 på 1 dag
(561 bedømmelser)

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. Flere

$30 AUD på 1 dag
(384 bedømmelser)

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 på 1 dag
(308 bedømmelser)

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 Flere

$10 AUD på 1 dag
(248 bedømmelser)

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 Flere

$30 AUD på 1 dag
(195 bedømmelser)

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 Flere

$19 AUD på 1 dag
(288 bedømmelser)

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 på 1 dag
(264 bedømmelser)

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

$30 AUD på 1 dag
(126 bedømmelser)

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 Flere

$30 AUD på 1 dag
(60 bedømmelser)

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 in 7 dage
(190 bedømmelser)

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 på 1 dag
(140 bedømmelser)

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. Flere

$32 AUD in 2 dage
(118 bedømmelser)

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 Flere

$15 AUD på 1 dag
(79 bedømmelser)

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 Flere

$20 AUD på 1 dag
(91 bedømmelser)

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 Flere

$30 AUD på 1 dag
(16 bedømmelser)

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 Flere

$20 AUD in 7 dage
(2 bedømmelser)

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 på 1 dag
(8 bedømmelser)