| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I shorten a number?
Hi,
If the 10-digit numbers are in A2:A101, enter the following formula in B2 and enter. Autofill the formula down to B101. =LEFT(A2,6) If you don't want the original numbers any more, select and copy B2:B101, "Edit" -- "Paste Special" -- "Values" -- "OK". Then delete Column A. Regards, B. R. Ramachandran "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 that possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| Change number format from text to number? | New Users to Excel | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
