Completed

Formatting Excel Cells

FREELANCER :

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:

michaeljhill07

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
(1 Review)
0.0

53 freelancers are bidding on average $21 for this job

jaylancer43

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 More

$35 AUD in 1 day
(719 Reviews)
8.5
schoudhary1553

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
(339 Reviews)
8.0
sergiuloghin

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)
7.6
pandey2008

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
(561 Reviews)
7.6
leelakalidas32

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
(384 Reviews)
7.3
P0L

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)
7.3
sparkingboy2010

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
(248 Reviews)
6.9
priyal1997

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)
6.8
eltamarisa85

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)
6.9
sohandas

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
(264 Reviews)
7.0
paulmd369

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
(126 Reviews)
6.5
mahfuz80

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)
6.4
bdoutsource

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)
6.7
teenasethi

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)
6.1
younus15

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)
6.0
sultanang464

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
(79 Reviews)
5.3
standarditech

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)
5.0
StormLion227

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
(16 Reviews)
5.0
webdesign786

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)
4.2
umairabdillah12

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