LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
chermaine
 
Posts: n/a
Default How can i put a negative sign on a range of selected cells?

I would like to know is there a way to help putting a negative sign on
the selected cells.
Actually I have to transform the +numbers filled in the cells into a
negative numbers by simply putting a negative sign in front. Right now
i am so stupid by amend each cell whereas i have at least 50 cells to
change, so I wonder is there a way can speed up these kind of data
entry process??

 
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
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN JON Excel Discussion (Misc queries) 3 July 18th 05 06:35 PM
Automatically put negative sign in cells with positive numeric dat ctdak Excel Discussion (Misc queries) 4 June 24th 05 09:41 PM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 2 May 2nd 05 08:53 AM
Can a formula check for a certain value in a range? Lee IT Excel Discussion (Misc queries) 3 April 8th 05 07:36 AM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 0 April 7th 05 12:47 AM


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

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

About Us

"It's about Microsoft Excel"