How can I remove the trailing "1" from a worksheet.
On Saturday, February 23, 2013 10:45:08 PM UTC+5:30, wrote:
I have a long column of numbers some large numbers, but they all have a "1" at the end.
How can I use excel to truncate the trailing digit from every entry?
for instance.
801
1761581
etc...
should read
80
176158
Thanks,
Crzzy1
Or Simply u can keep
=(A2-1)/10
|