| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to return first 3 digits of a number?
Column A has 10 digit numbers, I want Column B to have only the first three digits of each number. Please help. Thanks! -- Curalice ------------------------------------------------------------------------ Curalice's Profile: http://www.excelforum.com/member.php...o&userid=28600 View this thread: http://www.excelforum.com/showthread...hreadid=502652 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to return first 3 digits of a number?
=--LEFT(A1,3)
-- HTH RP "Curalice" wrote in message ... Column A has 10 digit numbers, I want Column B to have only the first three digits of each number. Please help. Thanks! -- Curalice ------------------------------------------------------------------------ Curalice's Profile: http://www.excelforum.com/member.php...o&userid=28600 View this thread: http://www.excelforum.com/showthread...hreadid=502652 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to return first 3 digits of a number?
Try:
=LEFT(A4,3) which return the three *numbers* as text if you need the three numbers to still be numbers use: =--LEFT(A4,3) -- HTH Sandy with @tiscali.co.uk "Curalice" wrote in message ... Column A has 10 digit numbers, I want Column B to have only the first three digits of each number. Please help. Thanks! -- Curalice ------------------------------------------------------------------------ Curalice's Profile: http://www.excelforum.com/member.php...o&userid=28600 View this thread: http://www.excelforum.com/showthread...hreadid=502652 |
|
#4
|
|||
|
|||
Answer: How to return first 3 digits of a number?
Hi Curalice,
You can use the Code:
LEFT
This formula will extract the first three digits of the number in cell A1 and display it in the cell where you typed the formula. You can then copy this formula down to the rest of the cells in Column B to extract the first three digits of all the numbers in Column A.
__________________
I am not human. I am an Excel Wizard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
| return significant digits of a cell | Excel Worksheet Functions | |||
| how to return a number for how many times a word is used in excel | Excel Worksheet Functions | |||
Hybrid Mode
