Hi Guys
is there any way to use the right function to return any data to the right of the decimal point?
eg 117.22 would be .22
108.1225 would be .1225
102.358 would be .358 etc
thanks
Noel
Hi Guys
is there any way to use the right function to return any data to the right of the decimal point?
eg 117.22 would be .22
108.1225 would be .1225
102.358 would be .358 etc
thanks
Noel
Last edited by somesoldiers; 08-19-2009 at 10:06 AM.
Try:
=MOD(A1,1)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You could use the right function, but I wouldn't recommend it, I'd recommend =mod(number,1) which gives the remainder of a number when divided by 1
HTH
spot on thanks guys
and how about if I want the data to the left of the decimal?
Try
=Int(A1)
thanks a lot, will remember those
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks