Hello from Steved

I have 4 numerals say 1234 what trim function would I use please to return
a 3 numeral value ie 123

Thankyou.

=LEFT(A1,3)*1

Biff

"Steved" wrote in message
...
Hello from Steved

I have 4 numerals say 1234 what trim function would I use please to return
a 3 numeral value ie 123

Thankyou.

Thanks Biff

"Biff" wrote:

=LEFT(A1,3)*1

Biff

"Steved" wrote in message
...
Hello from Steved

I have 4 numerals say 1234 what trim function would I use please to return
a 3 numeral value ie 123

Thankyou.

Or divide by 10 and truncate to an integer...


--
SuperDave
------------------------------------------------------------------------
SuperDave's Profile: http://www.excelforum.com/member.php...o&userid=25935
View this thread: http://www.excelforum.com/showthread...hreadid=393091

Hello SuperDave from Steved

Could you please give me an example ie 1234 to 123 using divide by 10 and
truncate to an integer

Thankyou.

"SuperDave" wrote:


Or divide by 10 and truncate to an integer...


--
SuperDave
------------------------------------------------------------------------
SuperDave's Profile: http://www.excelforum.com/member.php...o&userid=25935
View this thread: http://www.excelforum.com/showthread...hreadid=393091

One way:

=INT(1234/10)

In article ,
Steved wrote:

Hello SuperDave from Steved

Could you please give me an example ie 1234 to 123 using divide by 10 and
truncate to an integer

Thankyou.

"SuperDave" wrote:


Or divide by 10 and truncate to an integer...