Find Jobs
Hire Freelancers

CSV Issue! Barcode will not remain in number format

$10-30 USD

Cancelled
Posted about 7 years ago

$10-30 USD

Paid on delivery
Hi, I'm trying to upload my CSV to Shopify, but the barcode will not save in number format. After you save it, close and then reopen, it reverets to formula. I'm looking for an excel EXPERT. I've already tried all the basic settings, checked Google, spoke to Shopify, called friends, family and neighbors.... I need someone who's an expert with CSV and may know what the issue is, before even looking at it. When you open it in Google sheets or EXCEL, it displays fine: [login to view URL] But when you open it as a CSV, it changes: [login to view URL] Please see CSV attached. And test it yourself. No matter what settings I apply, it continues to happen. Everytime you save format and close/reopen it goes back. It seems to be an issue or bug related to CSV only. But as you can see, the first 650 lines are Okay, so if you can figure out the issue, let's talk.
Project ID: 13193936

About the project

30 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
30 freelancers are bidding on average $27 USD for this job
User Avatar
Hello Sir, I have done similar projects before. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$34 USD in 1 day
5.0 (816 reviews)
8.8
8.8
User Avatar
Its solved. Hi there. I am a excel expert. I checked your screen shots and csv. From 653-4228 has some formatting issues. I can be done in an hour. Best, Ethan
$50 USD in 1 day
4.9 (432 reviews)
8.6
8.6
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$50 USD in 1 day
4.9 (426 reviews)
8.3
8.3
User Avatar
Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$30 USD in 1 day
4.9 (432 reviews)
8.1
8.1
User Avatar
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 USD in 1 day
5.0 (479 reviews)
8.0
8.0
User Avatar
I am top rated in Data Entry. I am ready to do trial work now. You can check my profile and thousands of reviews. Discuss with me if you need high quality and fast delivery. We can adjust budget upon discussion. I will wait for your reply Regards Sultan
$30 USD in 1 day
4.9 (768 reviews)
8.2
8.2
User Avatar
Hello Sir, Experienced spreadsheet expert FREELANCER HERE to work for your project. Just recently i did this type of project. Let's discuss more and finalize the project and cost. Feel free to ask me questions, if any. I look forward to work with you. Have a good day and stay fine :-) Sincere regards, Jubair
$25 USD in 1 day
4.9 (333 reviews)
7.8
7.8
User Avatar
Hi there! I am specialist on scraping data from any kind of websites including frequently blocking sites. Also an expert on all of data entry & research jobs. I’m ready to start it right away. I look forward to hearing from you. Regards
$30 USD in 1 day
4.8 (278 reviews)
7.4
7.4
User Avatar
A proposal has not yet been provided
$29 USD in 1 day
4.9 (221 reviews)
7.4
7.4
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$20 USD in 0 day
5.0 (307 reviews)
7.3
7.3
User Avatar
Hi, I am expert in doing such tasks and ready to do it as per according to your needs. I assure you to provide you best quality results without errors. Lets discuss further and get started. You can check my profile for work experience. Thanks
$25 USD in 1 day
4.8 (162 reviews)
6.6
6.6
User Avatar
Hello, I am proficient with Excel and VBA and I have experience with problems similar to this one. Also, I have experience with uploading products to Shopify. I am familiar with the format needed for bulk upload. Please contact me for more information. EDIT: Ok, after downloading your file and playing around with it, I can confirm that I can fix this issue. Actually, I already fixed it and I am willing to explain to you how to do it.
$30 USD in 1 day
4.9 (143 reviews)
5.9
5.9
User Avatar
I am a skilled freelancer who has a working experience of more then 4 year I have working experience on- Web Research, lead generation, data entry, data mining, lead collection, All types of scrapping tools like - data toolbar, web hearvy, VWR etc..... I have great experience that would fit best. if hired by you i will deliver work of high standard and provide exceptional contribution in serving your task.
$30 USD in 1 day
4.7 (47 reviews)
5.6
5.6
User Avatar
Hi, I am an Australian-based Excel developer and a scientist by profession. I have had a look at your file, and I know why your large numbers are being displayed in scientific format. Unfortunately this display issue is not something which can be helped in a .CSV file format, but I can advise you on how to quickly change the display once the file is opened. Thanks, Dan
$25 USD in 1 day
5.0 (52 reviews)
5.3
5.3
User Avatar
Hello, I hope that You find my quote reasonable. The problem is that Excel has limit of 11 figures in one cell which can be displayed properly with number formatting. You can convert them like this, assuming that barcode with more than 11 numbers is in cell A1 (it still has all figures visible in formula bar): =TEXT(A1,0) Regards
$17 USD in 1 day
5.0 (62 reviews)
5.3
5.3
User Avatar
Hi Greetings, I have read your project description and ready to assist you on this project. It says that you are looking for someone who knows Microsoft Excel and also who is a detail-oriented person. I think that I am the right person for the job. I prepare Customized reports, Company accounts, Corporate employee analysis, Credit Card Usage analysis, Budget and Forecast. I am Advance excel user my excel usage includes but not limited to: 1. Advance Formulas, 2. Charting 3. Formatting 4. Pivot chart & Pivot table 5. Data analysis My four years in college plus my work experience as shown in my profile have helped me develop mastery in Word and Excel. As a data entry specialist, I also am detail-oriented. Rest assured all the data will be accurately entered, no more, no less. Consider me for this Project and i am confident that i will be able to fulfill the requirements of the project. I am looking forward to discussing with you about this job post. Leave me a message in messenger I will contact you as soon as possible. Respectfully,
$20 USD in 1 day
4.9 (20 reviews)
4.1
4.1
User Avatar
Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Izza Zubair
$25 USD in 1 day
5.0 (3 reviews)
3.2
3.2
User Avatar
Do not worry. This is just the default behavior of MS Excel. Please use the formula TEXT( ref , "#####################") in any other column and then copy this cell and past it as past special values. Then save the file and re-load it. Contact me if you still have any issue. Thanks
$30 USD in 1 day
5.0 (7 reviews)
2.3
2.3
User Avatar
Hlw, Sir, i am a Data Entry specialist. i am new in freelancer, bt i have done many project without freelancer. i have a team with 5 member. Recently i have done complete a project like this. I am very much Familiar with this work. I will do this with fast and 100% accuracy. i try my best hard working for you. plz, Sir, I hope i will get a chance to work with you. Just message me for more details. Thank you.
$25 USD in 1 day
5.0 (3 reviews)
1.0
1.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Tallman, United States
4.9
95
Payment method verified
Member since Apr 15, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.