On 2002-03-23 08:37, AJ wrote:
What you could say is, if A1 = 59, then
=LEFT(A1)*10 will give you 50
=RIGHT(A1) will give you 9.
Rgds
AJ
This message was edited by AJ on 2002-03-23 08:37
On 2002-03-23 08:57, Yogi Anand wrote:
Hi Aladin:
Following up on this thread, rpwagner wants to see the place 10-digit 5 as 50, so your first line would be:
=(LEFT(A1)+0)*10, and the 0-place digit then
=RIGHT(A1)+0