Posted to microsoft.public.excel.misc

JcR

Posts: n/a

enter 5 in 1 cell, show first 3 in other cell

I want to be able to:

enter a 5 digit number into in cell a1

have the first 3 digits appear in cell a2

Thanks

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
Determine a cell's width and enter it in the cell	Leonard615	Excel Discussion (Misc queries)	2	December 24th 05 06:55 PM
Stop next cell being selected on Enter	Jeff Stevens	Excel Discussion (Misc queries)	0	December 6th 05 06:55 AM
for the experts	Herman	Excel Discussion (Misc queries)	2	October 28th 05 11:59 PM
show macro security setting in a cell	Mark	Excel Worksheet Functions	3	March 21st 05 07:53 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

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

About Us

"It's about Microsoft Excel"