Quote:
Originally Posted by jolinchew
display error, I want to change column U, for example from 4.000002E13 to 40000165342013, pls see attached. how to do? why it display like ***2E13, how to prevent this.
also if I have cell "12345672013", how to make it by trail 2013 in the cell, I want it to be "1234567"
|
This appears to be 2 issues so here are 2 solutions.
It appears that the first issue is dealing with what is called scientific notation. Besides converting the cell to text you could add a ' into the result cell. an example would be to place this formula in cell u1 ="'"&a1
the quotes are around the ' so it is " ' " without the spaces. This will show the whole number. If you need to do calculations with it calculate the value in A1 not U1. U1 is just so you can see the number.
Now the 2nd issue could be accomplished by the formula =right(a1,4)
This will take the last 4 characters of a string and display them. so 01234567892013 will show 2013. Again if you need to do calculation on this change the formula to =right(a1,4)+0
Let me know if this makes sense.
Thanks