LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default MACRO: How to change cells to negative value

For something that seems so simple, I cannot come up with
a solution.

I want to run a macro that will change the contents of a
cell from a positive number to a negative number.

For example, if I have 1000 in A1, I will select A1 and
run a macro that will change its value to -1000.

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Defining cells that macro will change John K Excel Worksheet Functions 2 August 18th 09 11:49 PM
Need formula to change cells from negative numbers to a zero. CPS Nevada Excel Worksheet Functions 2 February 11th 09 12:09 AM
Format cells to change a number from a positive to negative jagfan123456 Excel Worksheet Functions 4 September 12th 06 06:35 PM
change 2000 cells (negative numbers) into positive numbers lisbern Excel Worksheet Functions 2 August 16th 06 05:54 PM
How can I change positive numbers to negative, i.e. change 50 to - godwingi Excel Discussion (Misc queries) 5 February 28th 05 05:41 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"