LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MS MS is offline
external usenet poster
 
Posts: 26
Default Column of negative numbers

Is it possible to highlight and format a part of a column before entering
data so that whatever entered is a negative number? This way i do not have
to press the minus sign before entering the number.

Thank u
ms
 
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
How do I make a column formatted for only Negative Numbers? DeeDeeCee New Users to Excel 4 September 5th 07 11:14 AM
column of negative numbers into positive numbers ORLFREIGHTBOY Excel Worksheet Functions 2 March 1st 07 08:26 PM
Excel Formula - Add column of numbers but ignore negative numbers view for Distribution List members Excel Worksheet Functions 1 April 7th 06 03:13 AM
Formula to ignore negative numbers in a column? Tia Excel Worksheet Functions 3 February 4th 06 02:53 PM
How do I change the plus to a negative in a column of numbers? JKB Excel Worksheet Functions 2 August 3rd 05 02:24 PM


All times are GMT +1. The time now is 04:28 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"