Shorten a number

rifpool

Board Regular
Joined
May 13, 2006
Messages
71
How do I....

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

I want to drop the last 2 numbers.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
If you want a formula try this.

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

rifpool

Board Regular
Joined
May 13, 2006
Messages
71

ADVERTISEMENT

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

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top