View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] thecjguy1@gmail.com is offline
external usenet poster
 
Posts: 2
Default How can I remove the trailing "1" from a worksheet.


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