Figure is not appearing properly

[Guest]

Hello!
I'm using Office 2K. Just few days back I have installed Analysis Toolpack.
Now when I'm putting figure 1500 excel shows 15. To see 1500 I have to put
15.00 then it shows 1500.
What could be wrong with my excel. Please help.
Thanks for time spent on this question.

Regards
Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com

 

[Mangesh Yadav]

Try Format > Cells > General

Mangesh

 

[Guest]

Thanks for help! But it is not working. Still same problem continue.

 

[Mangesh Yadav]

did you select all the cells before doing the above...?

Mangesh

 

[Piranha]

Hello!
I'm using Office 2K. Just few days back I have installed Analysis
Toolpack.
Now when I'm putting figure 1500 excel shows 15. To see 1500 I have to
put
15.00 then it shows 1500.
What could be wrong with my excel. Please help.
Thanks for time spent on this question.

Regards
Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com

Hi,
How about the fixed decimal tic mark in
tools/options/Edit
Thx
Dave

 

[Guest]

Thanks Piranha! I got it. Nice suggestion.

Regards