LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default negative fractions

I am having a problem with negative fractions. I am using MS Excel version
11.0 on Windows 2000 SP4, signed in as administrator. When I try formatting
cells as #?/?
or ?/? I find that the cell value becomes converted to a positive number.
The values that I am using only need to be one significant figure as I am
using ±1/3 and ±2/3.
Any ideas of some kind of custome format that addresses negative values? I
am using both negative and positive values and then adding all of the values
in a short column of typically 6 cells. Thanks in advance.
 
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
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM
I Need a formula to evaluate a cell with + or - values Bob in Oklahoma Excel Worksheet Functions 6 October 31st 05 02:41 PM
irritating warning for negative data on log charts Roger Charts and Charting in Excel 0 September 10th 05 12:04 AM
Negative Values Only [email protected] Excel Discussion (Misc queries) 1 August 8th 05 08:58 PM
How do I replace a negative number at the end of a formula with a. dealn2 Excel Discussion (Misc queries) 5 December 23rd 04 07:47 PM


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