Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing the last two digits of a cell
Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing the last two digits of a cell
in an adjacent column
=left(a1,14) and copy down -- HTH Bob Phillips (remove xxx from email address if mailing direct) "kestrel" wrote in message ... Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing the last two digits of a cell
=INT(A1/100)
where A1 is the number Note: 16-digit #s are stored as 15-digits with the last one being a 0. "kestrel" wrote: Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing the last two digits of a cell
If you want to remove the last 2 digits (avoiding rounding issues) and want
to keep it a number, you might want to try: =--LEFT(B1,14) -- Kevin Vaughn "Bob Umlas, Excel MVP" wrote: =INT(A1/100) where A1 is the number Note: 16-digit #s are stored as 15-digits with the last one being a 0. "kestrel" wrote: Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |