Keyboard shortcut

E

Eeyan

Hi,

Can anyone tell me if there is a keyboard shortcut to change the contents of
a cell from positive to negative and vv. Eg. +2134 to -2134. Especally
for monetary values.

TIA
 
R

Roger Govier

Hi

No keyboard shortcut, but if you enter -1 into a spare cell, then copy
that cell.
Mark any range of cells where you want to convert from positive to
negative and Paste Special>Multiply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File of a photo exist 1
split string based on a SET of words 8
Remove a - from text 5
Keyboard shortcut to follow hyperlink? 1
Date formatting 4
Keyboard shortcut for worksheet tabs 4
Shortcuts on french keyboard 2
Keyboard Shortcut 3

Top