Recover some corrupt excel data

Closed Posted Apr 8, 2014 Paid on delivery
Closed Paid on delivery

We have a large excel spreadsheet and some of the phonenumbers have become corrupt displaying as things like 4,41405E+11. We have found on some it still reads 4.41761E+11 even when you increase the cell width, but when you click on the cell, you can see that the number is actually 441761470142. I did a =text(cell,”0”) and then saved as values and the number then displayed correctly, we are looking at recovering all the numbers.

The sheet is attached, when quoting I would be grateful if you could provide some samples of recovered data as well as the cell refrences for me to check.

[login to view URL]

Excel

Project ID: #5778657

About the project

42 proposals Remote project Active May 15, 2014

42 freelancers are bidding on average £58 for this job

jaylancer43

Hello - 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 More

£100 GBP in 3 days
(821 Reviews)
8.9
Ibrahim185

sir, i am highly interested and dedicated to do this task. let's discuss and start. i am awaiting for your positive reply. thanks

£25 GBP in 1 day
(671 Reviews)
8.1
paris2785

Excel and VBA expert for over a decade. Master in Information Systems. Please check my feedback at https://www.freelancer.gr/u/paris2785.html I have figured out what needs to be done (1 minute work). Just pm me More

£20 GBP in 1 day
(363 Reviews)
8.1
FINGERRPRINT

this can be done with a simple twick I can show you how, i tried downloading the file from your url, but it is missing. hope you would consider my bid

£42 GBP in 1 day
(240 Reviews)
7.9
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

£40 GBP in 0 days
(330 Reviews)
7.7
livegoodlife

Hello sir how are you. the URL dose not contain any file . i hope i can do this work for you too. please provide me the file to start the work

£20 GBP in 1 day
(221 Reviews)
7.8
aarifakhtar

Hi: The data is not corrupt. The Excel thinks that the phone number you entered is a number. As the number is large so it converts it to exponential form. For example: 441761470142 can be written as 4.417614 * 10^11. I More

£20 GBP in 0 days
(168 Reviews)
7.1
sy3d

please check my reviews for my expertise area and buyers saying about my work if you check my feedback, then you see there is no incomplete work/bad sayings please check my profile here https://www.freelancer.com/u/ More

£22 GBP in 0 days
(293 Reviews)
7.3
DeepSyaal

Lets Start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more?

£40 GBP in 1 day
(203 Reviews)
6.5
gokulanand

Hello, I saw your master file and yes some of the phone numbers ( column I, J ) looks like corrupted. The value gets displayed as 4,41298E+11. Even I double click the cell, the value looks the same way ( 4,41298E+11 More

£35 GBP in 0 days
(113 Reviews)
6.1
sknadeem123

A proposal has not yet been provided

£26 GBP in 3 days
(70 Reviews)
6.3
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

£100 GBP in 6 days
(115 Reviews)
6.3
dynamitewebsol

Hello sir, i read your requirements very-well and ready to start work from now. Hope you will give me a chance to do work with you, waiting for your reply, Thank you

£100 GBP in 3 days
(11 Reviews)
5.2
tomislav1975

Excel Guru here :). That is nick my customer gave me. I can do this. Please let me do this. With regards

£40 GBP in 3 days
(34 Reviews)
5.3
swapnilchavan18

I have read the project description.I am interested to work on this project. I have 5 years of experience in it I am confident about the project to finish. Lets discuss.

£80 GBP in 3 days
(15 Reviews)
4.9
saminatinny

Dear Sir, It is my great honor to apply for this vacant job. I am very hardworking and can work effectively as fast as I can. I have excellent skills in Data Entry, Web Research and Microsoft Office,,SEO,WEB DESIGN,SE More

£23 GBP in 3 days
(38 Reviews)
5.0
ishfaq8

Hi there, Your project kinda interesting but the link you provided is no longer working. Could you just upload your file to Dropbox or something?

£20 GBP in 1 day
(17 Reviews)
4.4
dank111

Hi, My name is Dan. I will give you the tip right here. The link to the source file does not contain the file anymore to do the sample. So here is the tip - 1. Select the entire column which has the phone num More

£20 GBP in 0 days
(10 Reviews)
4.3
treshakhanom

Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job. I see your project and i do it as your acceptation. I have 3 years experience to w More

£23 GBP in 0 days
(38 Reviews)
4.8
mabbasalee

I am able to do your task please provide the file to show you my sample work, the file is not available on provided link any more. Looking forward for your kind response Regards Abbas

£250 GBP in 3 days
(2 Reviews)
4.7