A1
168153308099000000000
B1
1.6815
The formula for B1 is =LEFT(A1,LEN(A1)-11). For some reason B1 is showing 1.6815 instead of 1681533080.
I have a long list with the same formula and every other cell is working properly, I know it has to do something with the length of the cell because the number in A1 is so long. Any ideas on how to fix this issue?
much appreciated.
Hi, welcome to teh forum
excel only allows 15 digits for numbers, what you have is 21 characters lomng, so excel converts that to 1.6815330809900000E+20
if you use your formula on that, then the answer you get is correct
what exactly are you trying to do?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Would it work if you brought the number down by a billion?
Formula:Please Login or Register to view this content.
Good one, AlKey
Or try this ...
=TRUNC(A1/10^11)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks