Posted to microsoft.public.excel.programming

Steph[_6_] Steph[_6_] is offline

external usenet poster

Posts: 92

Switch Signs

Hi everyone. I have a large block of data. In column A is an account
number. In columns B thru Z is numerical data. Is there a way to
programatically scan column A, and if the last 4 characters in the contents
of column A are 888Z, then change the sign of the numbers in columns B thru
Z of the same row? Thanks in advance!

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 remove a * signs from name	virag	Excel Discussion (Misc queries)	2	March 18th 10 06:26 AM
pound signs	awh	Excel Discussion (Misc queries)	3	June 28th 07 07:46 PM
# signs where there shouldn't be....	dramajuana	Excel Discussion (Misc queries)	1	August 14th 06 10:20 PM
# signs where there shouldn't be....	MarkM	Excel Discussion (Misc queries)	0	August 14th 06 07:34 PM
# signs where there shouldn't be....	[email protected]	Excel Discussion (Misc queries)	0	August 14th 06 07:29 PM

All times are GMT +1. The time now is 02:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us