# Help with what I believe is a simple excel formula!!!!!!!

=?Utf-8?B?Um9iZXJ0TQ==?=
Guest
Posts: n/a

 11th Mar 2006
I just want to shave off the last two digits.

In a spreadsheet I want to turn this:

600134902
604117903
608313904

Into this:

6001349
6041179
6083139

davesexcel
Guest
Posts: n/a

 11th Mar 2006

=LEFT(A7,7)

maybe this will work

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708

=?Utf-8?B?d2lkbWFu?=
Guest
Posts: n/a

 11th Mar 2006
There are several answers depending on what you really want to end up with.
You could
1. Divide by 100 and not show decimals (or round to no decimals)
2. Same as above through past special
3. Use function: =left(a1,7) if your data was in A1 and you 7 digits.

And certainly a few others

"RobertM" wrote:

> I just want to shave off the last two digits.
>
> In a spreadsheet I want to turn this:
>
> 600134902
> 604117903
> 608313904
>
> Into this:
>
> 6001349
> 6041179
> 6083139

=?Utf-8?B?U1ZD?=
Guest
Posts: n/a

 11th Mar 2006
If the first number is in cell A1, in cell B1 type =Left(A1,LEN(A1)-2). This
will cut off the last two digits, regardless of the length of the number in
cell A1. Copy the formula down as far as necessary. Then select the entire
column, copy, then Edit > Paste Special, and select Value. Click OK. This wll
remove the formula from the cells in column B.

"RobertM" wrote:

> I just want to shave off the last two digits.
>
> In a spreadsheet I want to turn this:
>
> 600134902
> 604117903
> 608313904
>
> Into this:
>
> 6001349
> 6041179
> 6083139

=?Utf-8?B?U0s=?=
Guest
Posts: n/a

 11th Mar 2006
First if you have anything in the column to the right that you want to keep -
insert a new column. Then highlight only the data that you want to change
and click on the tool bar "Data" and use "text to columns" mark the "fixed
width" box - next button. on the data Preview screen left click and more the
line to the spot you want and click on next - then finish. That's it! -
delete the column that has the excess digits and you are done. Don't you
just love Excel???

"RobertM" wrote:

> I just want to shave off the last two digits.
>
> In a spreadsheet I want to turn this:
>
> 600134902
> 604117903
> 608313904
>
> Into this:
>
> 6001349
> 6041179
> 6083139

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Podberezovik Microsoft C# .NET 3 2nd Aug 2007 08:02 AM raylopez99 Microsoft Windows 2000 Networking 3 11th Feb 2007 02:31 PM pvdg42 Microsoft ASP .NET 5 24th Apr 2006 03:34 AM craigwojo Microsoft Excel New Users 3 29th Aug 2004 05:32 AM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM

Features