Hi,
Could someone inform why a text value of 19 chars looses the last 4 chars when converted to a number?
See attached?
TX
Loosing numbers on conversion?
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Loosing numbers on conversion?
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78446
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Loosing numbers on conversion?
Excel stores numbers with 15 significant digits, so anything over significant 15 digits is lost. Do you really need to perform calculations with 19-digit numbers?
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Loosing numbers on conversion?
It was a request from someone I am supporting.
I didn't actually ask why they wanted to convert it to a number as the string of digits is actually three smaller numbers concatenated. I doubt it is for summing, but anyhow, you answered the question with the fact that Excel only stored significant decimals to 15 characters. TX.
I didn't actually ask why they wanted to convert it to a number as the string of digits is actually three smaller numbers concatenated. I doubt it is for summing, but anyhow, you answered the question with the fact that Excel only stored significant decimals to 15 characters. TX.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.