Shorten a number

[rifpool]

How do I....

732 =7
745 = 7
702 = 7
855 = 8
945 = 9
1020 = 10

I want to drop the last 2 numbers.

 

[Norie]

If you want a formula try this.

=LEFT(A1, LEN(A1)-2)

 

[Oaktree]

=INT(A1/100)

 

[Brian from Maui]

If you want a formula try this.

=LEFT(A1, LEN(A1)-2)

For a numeric value,

=LEFT(A1, LEN(A1)-2)+0

 

[rifpool]

Thanks people. All 3 solutions work just fine, thanks.

I'm not sure what exactly is the difference between my ending value coming from a formula or by being numeric?

 

[PaddyD]

left(), being a text function, returns a text data item. this is going to choke some of the maths functions (e.g. sum() ). +0 coerces back to a number.

in general, better to find a mathematical route to the transformation if you can...

 

[Barry Katcher]

Yet another possibility:

Book1
	A	B	C	D
1	732	7
2	745	7
3	702	7
4	855	8
5	945	9
6	1020	10
7	11222	112
Sheet1