Posted to microsoft.public.excel.misc

osaka78

external usenet poster

Posts: 25

paste special

Dear Friends

Suppose if I have different values in cell A1:A100 and I want to divide all
of them by 10 and get the result rounded to 2 decimal place . how can I do
that by using paste special commend

regards

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
Paste Special and Linking	ajkim001	Excel Discussion (Misc queries)	8	March 14th 06 02:10 PM
Paste Special Problem	ajkim001	Excel Discussion (Misc queries)	1	March 10th 06 11:50 PM
strange Paste special	pmarques	Excel Discussion (Misc queries)	1	February 8th 06 07:18 PM
paste special - formulas	bjw10	Excel Worksheet Functions	6	February 1st 06 05:17 PM
Paste special treats cells as a picture	charlie	Excel Discussion (Misc queries)	2	November 17th 05 04:00 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us