Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert column of 4-5 digit whole numbers to 6? | Excel Discussion (Misc queries) | |||
show a column of numbers also as percentages | Excel Worksheet Functions | |||
Date format shows on formula bar, 5 digit numbers show in row | Excel Discussion (Misc queries) | |||
How do I shorten 10-digit # so only 6 digits show up? | Excel Discussion (Misc queries) | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions |