How do I get a column with 12 digit numbers to only show the 1st 1
 

I am trying to get a column with 12 digit numbers to only show 11 digits. The
last digit is not needed in filtering but I would like it to be there, just
not showing. I dont see where I can do that eaisly in the formatting. as an
example if I had 111111111112 I would want the 2, the last digit, hidden on
the worksheet.

How do I get a column with 12 digit numbers to only show the 1st 1
 

You can round to thousands (or million or trillion) through formatting....
but I don't think you can do that in tens as you want
"AA" wrote:

I am trying to get a column with 12 digit numbers to only show 11 digits. The
last digit is not needed in filtering but I would like it to be there, just
not showing. I dont see where I can do that eaisly in the formatting. as an
example if I had 111111111112 I would want the 2, the last digit, hidden on
the worksheet.