Negative Numbers

G

Glenda

Is there a way through formatting of cells to change
columns of positive numbers to negative or columns of
negative numbers to positive??

Appreciate your help,

Glenda.
 
A

Alex

Glenda

I think I can help.

Suppose column A has numbers 1 to 10 in cells A1:A10.

You want to change them to negative numbers. Left click on column A to
highlight the entire column. Then right-click on Column A and select <Format
Cells...>. In the Category menu select <Custom> [Usually at the bottom].
Underneath the word <Type> is a space to customise your own format. In that
space type '-#' [quotation marks not required]. Then click <OK>. That will
change your values to negatives.

To change them back to positive, follow the above plan but change '-#' to '#'.

I hope this helps. If not do write back and I will endeavour to assist
further.

Regards


Alex
 
B

Bob Phillips

This only changes the appearance of them, not the underlying value. If you
need the latter then do this

enter -1 in another cell
copy that cell to the clipboard
select the numbers to change
goto Edit>PasteSpecial
select the Multiply button in the Operation section
OK out

--

HTH

RP
(remove nothere from the email address if mailing direct)


Alex said:
Glenda

I think I can help.

Suppose column A has numbers 1 to 10 in cells A1:A10.

You want to change them to negative numbers. Left click on column A to
highlight the entire column. Then right-click on Column A and select <Format
Cells...>. In the Category menu select <Custom> [Usually at the bottom].
Underneath the word <Type> is a space to customise your own format. In that
space type '-#' [quotation marks not required]. Then click <OK>. That will
change your values to negatives.

To change them back to positive, follow the above plan but change '-#' to '#'.

I hope this helps. If not do write back and I will endeavour to assist
further.

Regards


Alex
Glenda said:
Is there a way through formatting of cells to change
columns of positive numbers to negative or columns of
negative numbers to positive??

Appreciate your help,

Glenda.
Click to expand...
Click to expand...
 
J

JE McGimpsey

One way:

Put -1 in an empty cell. Copy the cell. Select your column of numbers.
Choose Edit/Paste Special, selecting the Values and Multiply radio
buttons.
 
Top