Fermé

Excel Spreadsheet Long Numbers becoming scientific notation

This should be an easy task for an excel expert.

Attached is a sample spreadsheet. Column A contains some long numbers that appear in scientific notation in column A display

For example, row 6422 column A displays as 2.00812E+11 but the value in that cell is 200812037693 when you examine it.

When I import this xlsx to Microsoft Access 2010, I lose the 200812037693

The purpose of this project is to detail for me how to import this xlsx into Microsoft Access and THEN export it as a CSV and NOT lose the actual values.

I don't want the scientific notation I want the 200812037693

Please detail those steps using this attached spreadsheet.

Thank you

Compétences : Excel

Voir plus : convert excel numbers spreadsheet ipad, iwork numbers spreadsheet converted excel format, convert numbers spreadsheet excel, convert numbers spreadsheet excel spreadsheet, excel spreadsheet database customization project, numbers spreadsheet convert excel, convert apple numbers spreadsheet excel, convert excel spreadsheet numbers spreadsheet, convert excel numbers spreadsheet, convert excel apple numbers spreadsheet, excel project time management spreadsheet, excel engineering budget spreadsheet template, excel condo budget spreadsheet, excel project spreadsheet, incrementing numbers column macro excel, refresh spreadsheet view excel macro, copy numbers word document excel, spreadsheet features excel, excel project manage template web design, excel project macro, simple excel project grade

Concernant l'employeur :
( 257 commentaires ) United States

N° du projet : #12724423

41 freelance ont fait une offre moyenne de 64 $ pour ce travail

FINGERRPRINT

Changed happy to deliver now. Please message so send you the output Hi, This happens often, I can change displaying 2.00812E+11 to 200812037693, so you can import it to access and csv. Once we made the change it wou Plus

30 $ USD en 0 jours
(140 Commentaires)
7.1
shikhamehta

Hey, There are more than one ways to do what you are looking for. You may try number formatting the column or you may also use a macro that will do the desired export to Access. I can help you in both ways. Do le Plus

30 $ USD en 1 jour
(87 Commentaires)
6.1
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I have already done the same project. Please have a look on to this one. [url removed, login to view] Plus

30 $ USD en 0 jours
(87 Commentaires)
5.9
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet to turn the scientific format into desired one prior importing data into Access. I have 7 y Plus

70 $ USD en 1 jour
(93 Commentaires)
6.0
25 $ USD en 1 jour
(62 Commentaires)
5.8
bossumd

Hello! I have a great experience in Excel, so I can complete your project in short time. I'm able to start right now!

15 $ USD en 0 jours
(96 Commentaires)
5.6
25 $ USD en 1 jour
(68 Commentaires)
5.2
abdolah2014

its simple convert it to string ...................................................................................

250 $ USD en 10 jours
(30 Commentaires)
5.1
manwar4393

Dear sir I will start now I am web research, data entry and copy typing specialist. My typing speed is 100 word per minute. I am honest and hard worker. I will start now and deliver you before your deadline. I prov Plus

29 $ USD en 1 jour
(44 Commentaires)
4.7
ponnarasiBabu

In order to make your project a success, you need someone who has ample knowledge and a keen eye for detail, both of which I have. I read and understood your requirements and can start the work asap. Can remove those f Plus

277 $ USD en 10 jours
(30 Commentaires)
4.7
denisaelena

Hi sir Here is a gift for this 2017 year :) Select the A column, and then go and select Home Ribbon from the top, go to "Number" and the change from the drop down list the selection from "General", which I supose Plus

15 $ USD en 0 jours
(18 Commentaires)
4.5
rumarahman

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Finance Management Statistics Data Processing Data Collect Plus

20 $ USD en 0 jours
(10 Commentaires)
4.3
Saidul28

Hello , I am Saidul . I am expert in Data entry work. I have read your project details and I am a hard worker; I feel that I work quickly and concisely with little direction. I have excellent skills in all Microsoft O Plus

25 $ USD en 1 jour
(19 Commentaires)
4.3
vsprybhanu

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. Sorry but this is fact that there is no way to keep long numbers in CSV in normal case. Because when you format this number in X Plus

30 $ USD en 1 jour
(31 Commentaires)
4.2
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Plus

10 $ USD en 1 jour
(15 Commentaires)
4.0
archanaoswal

I have excellent command on MS Excel and MS Access. I can help you with importing data from and to Excel and Access About my experience in Excel I have completed complex projects in Excel before involving Userforms Plus

20 $ USD en 1 jour
(9 Commentaires)
3.4
ksinghrajeev

Attachment is missing. It looks like you just need help on retaining the number since you have modified the budget. I can do it. Ping me.

35 $ USD en 1 jour
(7 Commentaires)
3.7
250 $ USD en 1 jour
(10 Commentaires)
3.8
chintu83

I Can do it ...with less price too ..can you please send me file....Lets start work with great accuracy and within time [url removed, login to view] aim is to satisfy my client by my WORK.Thanks.

250 $ USD en 0 jours
(14 Commentaires)
3.8
jssinfosys

I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have extens Plus

25 $ USD en 1 jour
(9 Commentaires)
3.8