Posted to microsoft.public.excel.misc

MFS

external usenet poster

Posts: 36

three digits

I have some cells that have five digits, I want to take only the first three
digits.
pleas can you help me?

--
MFS22

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
How to customize number to 10 digits including 2 digits after deci	Carina	Excel Worksheet Functions	3	September 20th 07 02:50 AM
last 2 digits	rexmann	Excel Discussion (Misc queries)	2	March 6th 07 09:40 AM
last ten digits	Martina	Excel Worksheet Functions	5	December 1st 06 04:53 AM
2 DIGITS OUT OF 4	gregork	Excel Discussion (Misc queries)	9	February 20th 05 03:30 PM
2 DIGITS OUT OF 4	Knoxi	Excel Discussion (Misc queries)	0	February 19th 05 05:54 PM

All times are GMT +1. The time now is 12:19 AM.

About Us

"It's about Microsoft Excel"