some numbers are 10000 times bigger than they should

**miktush** · 06-17-2011, 03:10 AM

Hi all,

I'm really hoping I can get some help as this is driving me crazy.

When I import/download a balance sheet some numbers are 10,000 times bigger than they should be and some are ok. Roughly 50% of the numbers are randomly larger by exactly 10,000.
some numbers are in the correct format of eg. 0.4728 and then some are 11820.0000 and this should actually be 1.182!!!

please please help.

regards

KS - UK

**zbor** · 06-17-2011, 03:19 AM

Can you paste here also some original values that you importing and not result?

Or both... What's input, what you get, what you expect?

**miktush** · 06-17-2011, 03:49 AM

0.2724
0.4728
2.5288
0.6503
Hi and thanks for the swift reply, the first set of numbers is from a friend who used the same file and downloaded from the same place.
Friends
0.3351
13.7487
1.0935
14.3370
21.9361

1.3164

6.9360
0.0454
25.7604
63.6723
25.7604
89.4327

Mine
0.2724
0.4728
25288.0000
0.6503

0.3351
137487.0000
10935.0000
143370.0000
219361.0000

13164.0000

69360.0000
0.0454
257604.0000
636723.0000
257604.0000
894327.0000

**zbor** · 06-17-2011, 03:54 AM

This could help in next column:

=IF(A17="", "", MIN(A17, MAX(A17/10000, 1)))

**miktush** · 06-17-2011, 04:05 AM

Hi Zbor,

many thanks for this, it works great but is there any reason why when I import/download the same file from my friend that i get this issue. The spreadsheet has probably 200 numbers with 50% roughly 10,000 times higher so really trying to understand why this is happening?

Thanks again

KS

**zbor** · 06-17-2011, 04:11 AM

i really don't have a clue.

First I suspect on regional settings and difference between . (dot) and , (comma).

But I can't explain why it's not happening to all of them...

**royUK** · 06-17-2011, 08:22 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Edited this time, do not use unnecessary words in the title