Hai friends, I got one excel file

[foxuma2001]

Hai friends,
I got one excel file from my friend.
My problem here is :
The contents in A1 (ie the excess data from A1) doesnt flow to next cell, even though the next cell is empty. What formatting was made there? plz let me know.

Next doubt is ,I want to format the numeric figures entered in column D. That is, I want to make it as 2 decimal places. (ie) 100.00 like that.
I couldnt do anything. I couldnt even allign that.
Kindly let me know what formatting was made there?
As Iam desparate plz help.

 

[yanqui]

It sounds like your worksheet is protected. Have you check that? Try the Tools pull-down menu, then slide down to Protection and see what it shows. If your worksheet is protected, the cells can't be formatted any differently than the formatting that existed when the protection was enacted.

 

[GlennUK]

It sounds like you've got formula display switched on. Choose menu option Tools/Options/View and untick the Formulas checkbox.

Glenn.

 

[mblaster]

Try selecting the blank cell (where the text is not flowing) and Edit/Clear/All... does it flow now?