Posted to microsoft.public.excel.misc

RobertM

Posts: n/a

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

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting formula from lotus.123 to excel	zaharah	Excel Worksheet Functions	2	July 27th 05 03:04 PM
Excel Range Value issue (Excel 97 Vs Excel 2003)	Keeno	Excel Discussion (Misc queries)	2	June 13th 05 02:01 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
In excel the formula bar behaves differently on different machines	vijay	Excel Discussion (Misc queries)	0	May 20th 05 06:27 AM
Excel 2003 - Formula result shows as 0:00	Serena	Excel Worksheet Functions	4	November 11th 04 10:18 PM

All times are GMT +1. The time now is 07:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us