Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
Simplify formula | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |