i tried but it does not have any affect on the cell. still the problem is
there. i have even cleared all the data and formatting but still if i put any
number it goes to the left side and even if i try to calculate these numbers
but using any formula, it doesn't count rather it shows the formula on the
cell not the result.

"Dave Peterson" wrote:

Try changing the cell's format to General.
(Format|Cells|number tab)

What was it formatted like before?

create_share wrote:

i have an excel workbook in which there are 3 sheets. in one sheet when i put
any number it goes to the left side of cell and if i press the align left or
center button it does not work. i even changed the category to number but
still same problem. If i put english words, i can change everything.

thankx!

--

Dave Peterson