PC Review


Reply
Thread Tools Rate Thread

how to change the state of a number in a cell from negative to po.

 
 
=?Utf-8?B?U3RldmUxMQ==?=
Guest
Posts: n/a
 
      29th Nov 2004
What is the easiest way to change the gender of a number in a single cell or
columns of cells or rows of cells in a Exel spreadsheet
 
Reply With Quote
 
 
 
 
Frank Kabel
Guest
Posts: n/a
 
      29th Nov 2004
Hi
try:
- put -1 in an empty cell an copy that cell
- select your numbers
- goto 'Edit - Paste Special' and choose 'Multiply'

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve11" <(E-Mail Removed)> schrieb im Newsbeitrag
news:3D63ED33-0D1D-4472-AD08-(E-Mail Removed)...
> What is the easiest way to change the gender of a number in a single

cell or
> columns of cells or rows of cells in a Exel spreadsheet


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Negative Number - Brackets instead of negative signs J. Trucking Microsoft Access 3 29th Apr 2008 08:47 PM
Change a positive number to negative number patowens Microsoft Excel Discussion 4 23rd Jun 2005 07:55 PM
Change negative sign from end of number to the beginning of the number. GORDON SCALES via OfficeKB.com Microsoft Excel Programming 3 30th Jan 2005 09:05 AM
2003= negative number&2004= negative number How Do I Calculate gro =?Utf-8?B?SmFzb24=?= Microsoft Excel Worksheet Functions 1 14th Jan 2005 06:24 PM
Re: Importing negative numbers when negative sign is at the back of the number Ken Snell Microsoft Access External Data 3 5th Aug 2003 07:14 AM


Features
 

Advertising
 

Newsgroups
 


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