| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel will not allow me to change a numerical figure in a specifi. | Excel Discussion (Misc queries) | |||
| how to type a minues figure | New Users to Excel | |||
| excel to figure miles per gallon | New Users to Excel | |||
| Excel 2000 running on Windows XP SP2 does not properly open CSV fi | Excel Discussion (Misc queries) | |||
| The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions | |||
Linear Mode
