Figure is not appearing properly
 

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<athotmail<dotcom

Try Format Cells General

Mangesh


"Akhilesh Dalia" wrote in message
...
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<athotmail<dotcom

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

"Mangesh Yadav" wrote:

Try Format Cells General

Mangesh


"Akhilesh Dalia" wrote in message
...
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<athotmail<dotcom

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

Mangesh


"Akhilesh Dalia" wrote in message
...
Thanks for help! But it is not working. Still same problem continue.

"Mangesh Yadav" wrote:

Try Format Cells General

Mangesh


"Akhilesh Dalia" wrote in
message
...
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<athotmail<dotcom

Akhilesh Dalia Wrote:
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<athotmail<dotcom
Hi,
How about the fixed decimal tic mark in
tools/options/Edit
Thx
Dave


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=373795

Thanks Piranha! I got it. Nice suggestion.

Regards

"Piranha" wrote:


Akhilesh Dalia Wrote:
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<athotmail<dotcom
Hi,
How about the fixed decimal tic mark in
tools/options/Edit
Thx
Dave


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=373795