When I import a string that can be interpreted as a date, e.g. 1/4 or 6/12, Excel converts it into a date. That's not what I want it to do. I want to keep the original string. It's NOT a date! 1/4 means 1/4, not 1/4/2005 or even .25.
I created one workbook out of several sheets. Then I try to save it and Excel does not accomplish the task. It generates a message that goes: "The document did not save". I have office XP on WinXP working on AMD Athlon XP 2200.
I am trying to write a formula to correct negative %..... Example....-500 2005 -400 for 2004 Variance = -100 Variance % is showing 25% should be (-)25%......How to write formula?