LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
lil'bit
 
Posts: n/a
Default Strange formula popping up


Hello. I have a problem in excel 2003. My SS has lots and lots of
figures on it. I used format with no $ , 2 decimals, and chose (1234.
56). However every time I try to enter an amount in the minus in any
cell it comes out strange.

For instance say I want to enter (250.00).
It does this: - 250.F8 (or any other cell ). and then jumps to the cell
next to it and does the little flashing 'outline the cell' thingy. I
tried deleting and clearing all the formulas and then reformatting but
it keeps doing it. Amounts in the black come out just fine such as
1234.56. It only does it in a cell with minus.

What am I doing wrong? I don't want to lose all the data I have
entered but ....


--
lil'bit

married, muddled, and mistook
------------------------------------------------------------------------
lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306
View this thread: http://www.excelforum.com/showthread...hreadid=483572

 
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
writing a formula for a colored value aaronwexler New Users to Excel 11 September 1st 05 03:11 PM
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 09:16 PM.

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"