Numbers aren't changing with new format why?

C

Cyndy

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!
 
C

CLR

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
 
M

Myrna Larson

Sounds to me as though the column was formatted as text before you entered the
data. If that's the case, just changing the format to a number format will not
convert it from text to a number. You must change the format to a number
format. Then Edit/Copy a blank cell. Then select the misbehaving data and
Edit/Paste Special and select the Add option.
 
K

Kassie

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.
 
Top