Posted to microsoft.public.excel.misc

Colin Hayes Colin Hayes is offline

external usenet poster

Posts: 465

Boolean Operators In search and Replace

Hi

In Column D I have numbers to two decimal places.

I want to change all those below a certain number to a single higher
number. For example , all those less than 3.00 should become 3.00.

Is it possible to do this via the Find and Replace dialogue , or via
some code in a macro?

Any help appreciated.

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
Search and Replace	LymaBeane	Excel Worksheet Functions	2	September 13th 06 10:30 PM
Are there Boolean operators in MS Excel?	Aashu	Excel Discussion (Misc queries)	5	August 4th 06 02:41 PM
Search and Replace	Abdul	Excel Discussion (Misc queries)	2	March 23rd 06 02:38 PM
Search and replace	Subu	Excel Worksheet Functions	4	June 9th 05 07:01 PM
Search and Replace	Rebecca	Excel Discussion (Misc queries)	1	May 14th 05 11:53 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us