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

A

AA

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.
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate numbers in a column 2
How do I stop Excel from dropping leading zeros? 9
Excel Changes My Last Digit to Zero 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Extracting 7 digit number from alphanumeric string 10
How add a digit to front of number in each cell in excexl column 1
column contents alignment 4
How to Combine two cells (numbers) but not add 7

Top