# Shorten a number

#### rifpool

##### Board Regular
How do I....

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

I want to drop the last 2 numbers.

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### Norie

##### Well-known Member
If you want a formula try this.

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

=INT(A1/100)

#### Brian from Maui

##### MrExcel MVP
If you want a formula try this.

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

For a numeric value,

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

#### rifpool

##### Board Regular

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?

##### MrExcel MVP
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

##### Well-known Member
Yet another possibility:
Book1
ABCD
17327
27457
37027
48558
59459
6102010
711222112
Sheet1

Replies
3
Views
160
Replies
8
Views
144
Replies
17
Views
327
Replies
9
Views
312
Replies
1
Views
222

1,141,221
Messages
5,705,100
Members
421,378
Latest member
CarlosDuran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back