Thread: HO do I enter a number and have it always appear negative
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default HO do I enter a number and have it always appear negative
1. Enter the numbers to the range
2. Once done. enter -1 to a ununsed cell and copy the cell
3. With the copy ON; select the entered range of cells
4. Right clickPasteSpecialselect Multiply OK.

If this post helps click Yes
---------------
Jacob Skaria


"Shorichi" wrote:

Hi, i want all numbers in a range of cells to appear with a minus but want to
just enter the figures. Is this possible? Cheers
Reply With QuoteReply With Quote