Excel Spreadsheet Long Numbers becoming scientific notation

終了済み 投稿 7年前 着払い
終了済み 着払い

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

エクセル

プロジェクトID: #12724423

プロジェクトについて

39個の提案 リモートプロジェクト アクティブ 7年前

39人のフリーランサーが、平均$66 で、この仕事に入札しています。

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. [login to view URL] もっと

$30 USD 0日以内
(291件のレビュー)
7.8
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 もっと

$30 USD 0日以内
(195件のレビュー)
7.5
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 もっと

$70 USD 1日以内
(182件のレビュー)
7.2
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 もっと

$277 USD 10日以内
(107件のレビュー)
6.5
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 もっと

$30 USD 1日以内
(94件のレビュー)
6.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 もっと

$25 USD 1日以内
(36件のレビュー)
5.6
bilalsafdar111

Hi, First! Your satisfaction is my top priority.I read your project and ready to working for it. If you give me chance then i can start from now and able to provide best results. In short, I could produce exactly wha もっと

$25 USD 1日以内
(58件のレビュー)
5.5
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 もっと

$20 USD 1日以内
(78件のレビュー)
5.7
abdolah2014

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

$250 USD 10日以内
(37件のレビュー)
5.3
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 もっと

$20 USD 0日以内
(37件のレビュー)
5.1
Bestever786

Hi sir how are you hope you are well dear sir I am Expert in Excel I Can fix this problem for you if you really want quality work then please hire me for this job thanks

$25 USD 3日以内
(18件のレビュー)
4.9
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 もっと

$30 USD 1日以内
(49件のレビュー)
4.9
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 もっと

$29 USD 1日以内
(66件のレビュー)
5.2
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 もっと

$15 USD 0日以内
(21件のレビュー)
4.8
muturi123

Dear Client, Are you looking for an honest, credible and reliable writer? Then welcome on board to one of the most professional writer. I have handled several papers of this kind and always leave a mark of satisfac もっと

$35 USD 1日以内
(6件のレビュー)
4.0
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 1日以内
(13件のレビュー)
4.0
CreativeQueen

Hello, I'm ready now Easily do it. So I'm interested in this job, please let me know, if I can support you. Thanks & Regards, Mitu Akter.

$30 USD 10日以内
(24件のレビュー)
3.8
arugawade

Use below steps 1 right click convert col A - format - as Number to special form 2 insert one col extra to left and paste (paste special with value) 3 right click and format it as number category with zero decimal p もっと

$30 USD 1日以内
(18件のレビュー)
4.1
khanconsultancy

Hi i have much experience in data entry and online works i have done many projects of excel i can give you solutions regarding ms office other like data entry also online works. Please consider me for your work i ca もっと

$250 USD 10日以内
(10件のレビュー)
3.1
umeshj1982

Hi, Greetings of the Day!!!, My name is Umesh Joshi, a management professional by profession & I would like to know the details of the project. I have more than 8 years of experience in the field of Data Proce もっと

$20 USD 1日以内
(10件のレビュー)
3.0