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

Taidot: Excel, tiedonsyöttö, tietojenkäsittely, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 7 arvostelua ) Glendenning, Australia

Projektin tunnus: #20439358

Myönnetty käyttäjälle:


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 Lisää

$10 AUD 1 päivässä
(1 arvostelu)

53 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$35 AUD 1 päivässä
(719 arvostelua)

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. Lisää

$35 AUD 1 päivässä
(339 arvostelua)

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 1 päivässä
(267 arvostelua)

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 1 päivässä
(561 arvostelua)

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. Lisää

$30 AUD 1 päivässä
(384 arvostelua)

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 1 päivässä
(308 arvostelua)

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 Lisää

$10 AUD 1 päivässä
(248 arvostelua)

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 Lisää

$30 AUD 1 päivässä
(195 arvostelua)

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 Lisää

$19 AUD 1 päivässä
(288 arvostelua)

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 1 päivässä
(264 arvostelua)

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

$30 AUD 1 päivässä
(126 arvostelua)

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 Lisää

$30 AUD 1 päivässä
(60 arvostelua)

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 7 päivässä
(190 arvostelua)

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 1 päivässä
(140 arvostelua)

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. Lisää

$32 AUD 2 päivässä
(118 arvostelua)

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 Lisää

$15 AUD 1 päivässä
(79 arvostelua)

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 Lisää

$20 AUD 1 päivässä
(91 arvostelua)

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 Lisää

$30 AUD 1 päivässä
(16 arvostelua)

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 Lisää

$20 AUD 7 päivässä
(2 arvostelua)

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 1 päivässä
(8 arvostelua)