The key is the fact that your numbrs are left aligned. This means that
someone formatted this column as text. Click on the column tab, click on
Format cells, and format it as currency, 2 decimals. If your formulae still
do not work, try again what CLR wrote.

"Cyndy" wrote:

I retried these options but unfortunately they did not work. Thanks for
trying.Cyndy

"CLR" wrote:

Click on the cell, then click on the $ in the toolbar..........0.5 becomes
$0.50............

Click on the formula, then in the formula bar, delete the = sign and hit
Enter, then go back and put the = sign back in and hit Enter again.......the
cell should now display the result instead of the formula.......

Vaya con Dios,
Chuck, CABGx3




"Cyndy" wrote in message
...
Had my worksheet tampered with and haven't been able to restore my three
columns with numbers back to the original format. Had them set has
accounting, with 2 decimals and the $ symbol. Also the formula to add them
stays as the formula not the result. It's just basic addition nothing
else.
The numbers are staying to the left and unless I enter two numbers other
than
0 after the decimal it doesn't show. ie 50.00 shows as 50, 60.50 shows as
60.5. I have tried all that I could think of, please help!