View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
[email protected] srimanta@ereasoning.com is offline
external usenet poster
 
Posts: 1
Default 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