ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula Help (https://www.excelbanter.com/excel-worksheet-functions/190565-formula-help.html)

Buckeyes08

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!

Gary''s Student

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!

Brad

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!

All times are GMT +1. The time now is 09:53 AM.