I am trying to create a simple column to add numbers with dollar figures. When I have it formatted with just decimals (9999.99) it works fine. When I format the column with dollar signs as I want it ($9999.99) it adds $9900 to whatever figure is in the cell. So if I enter 42.50, when I leave the cell it reads $9942.50.
Actually when I tried using some larger numbers it just adds a nine to whatever is missing, so $780 becomes $9780.
What is going on with that? Is there a fix?
I tried throwing out permissions, logging out and starting again. Same deal. None of the other number options have the problem—only the one with the dollar sign.
Any help appreciated.
Actually when I tried using some larger numbers it just adds a nine to whatever is missing, so $780 becomes $9780.
What is going on with that? Is there a fix?
I tried throwing out permissions, logging out and starting again. Same deal. None of the other number options have the problem—only the one with the dollar sign.
Any help appreciated.
Last edited by MichaelG; 2008-06-02 at 09:47 PM.. Reason: more details
Threaded Mode