| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Does anyone know how I can convert a 13 digit ID number to a 9 digit ID
number by dropping the 4 zeroes off the end? Example: 1234567890000 to look like 123456789 Thanks in advance for your time and help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
=--LEFT(A1,9)
-- Gary''s Student - gsnu200790 "Buckeyes08" wrote: Does anyone know how I can convert a 13 digit ID number to a 9 digit ID number by dropping the 4 zeroes off the end? Example: 1234567890000 to look like 123456789 Thanks in advance for your time and help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help
another solution - assuming the 13 ID number is truly a number.....
=int(a1/10000) -- Wag more, bark less "Buckeyes08" wrote: Does anyone know how I can convert a 13 digit ID number to a 9 digit ID number by dropping the 4 zeroes off the end? Example: 1234567890000 to look like 123456789 Thanks in advance for your time and help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
