| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I shorten 10-digit # so only 6 digits show up?
I have a list of 10-digit numbers, but I want to apply a formula/function or
format the cells so that only the first 6 digits show up. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I shorten 10-digit # so only 6 digits show up?
Something like:
=INT(a1/10000) swingkittenva wrote: I have a list of 10-digit numbers, but I want to apply a formula/function or format the cells so that only the first 6 digits show up. Is this possible? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I shorten 10-digit # so only 6 digits show up?
=left(A1,6)
swingkittenva wrote: I have a list of 10-digit numbers, but I want to apply a formula/function or format the cells so that only the first 6 digits show up. Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I shorten 10-digit # so only 6 digits show up?
=left(A1,6)
"swingkittenva" wrote: I have a list of 10-digit numbers, but I want to apply a formula/function or format the cells so that only the first 6 digits show up. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert 9 digit zipcodes to 5 digits? | Excel Discussion (Misc queries) | |||
| Getting the first 3 digits out of 6 digit cells? | Excel Worksheet Functions | |||
| Mod 10 & 11 | Excel Worksheet Functions | |||
| Why is Excel changing the last 2 digits of a 17 digit num to 00. | Excel Discussion (Misc queries) | |||
| I have a col. with 6 digit nos to convert to 3 cols of 2 digits | Excel Discussion (Misc queries) | |||
Linear Mode
