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

Skills: Excel, Data Entry, Data Processing, Visual Basic

See more: 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

About the Employer:
( 7 reviews ) Glendenning, Australia

Project ID: #20439358

Awarded to:


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 More

$10 AUD in 1 day
(2 Reviews)

51 freelancers are bidding on average $21 for this 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 and have been featured by the freelancer community (g More

$35 AUD in 1 day
(723 Reviews)

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

$35 AUD in 1 day
(341 Reviews)

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 in 1 day
(267 Reviews)

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 in 1 day
(562 Reviews)

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

$30 AUD in 1 day
(391 Reviews)

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 in 1 day
(308 Reviews)

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 More

$10 AUD in 1 day
(252 Reviews)

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 in 1 day
(265 Reviews)

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 More

$30 AUD in 1 day
(195 Reviews)

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 More

$19 AUD in 1 day
(288 Reviews)

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

$30 AUD in 1 day
(127 Reviews)

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 More

$30 AUD in 1 day
(60 Reviews)

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 days
(190 Reviews)

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

$32 AUD in 2 days
(118 Reviews)

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 in 1 day
(140 Reviews)

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 More

$15 AUD in 1 day
(83 Reviews)

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 More

$20 AUD in 1 day
(91 Reviews)

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 More

$30 AUD in 1 day
(19 Reviews)

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 More

$20 AUD in 7 days
(2 Reviews)

Hi Good Day! A serious freelancer here. Let me do this please. I know how to do it using excel formula. I've done a lot of Report Templates using MS Excel. Please consider my bid. With my experience as a VBA Macro d More

$25 AUD in 1 day
(30 Reviews)