How do a shorten an 8-digit number to a 6-digit number?

[ABillmann]

Hi All,

I'm trying to figure out how to truncate 8-digit SIC codes to 6 digits. No rounding should be involved... the last two digits simply need to be dropped.

For example, the number

81119992

should become

811199

I've been playing with the TRUNC command, but it seems to only work with numbers coming AFTER a decimal. Technically, all of the numbers I'm working with are integers. I've also tried setting a custom format to ######, but that doesn't work either. What am I missing?

Any ideas? It seems pretty simple, but I just can't get it.

 

[barry houdini]

Try

=LEFT(A1,6)+0

where your number is in A1

 

[ABillmann]

Barry, you rule.

Thank you! That did it. Exactly. Beauuuuuutiful.

 

[ABillmann]

Barry, you rule.

Thank you! That did it. Exactly. Beauuuuuutiful.