06 August 2012
When I write any figure in excel worksheet it get reduced by two digit e.g. if I write 8000, it will be 80 and if I write 5 it will be seen as .05 and if I write 900.97 it remains 900.97. I have re installed excel programmes but still same. Can you help me please. AK Gupta
06 August 2012
Use the following steps:- *open excel *select full sheet using ctl+A *right click and then select "Format cells" *click on "number" and then reduce decimal points to "0" and then clic Ok Hope ur work will be done.
06 August 2012
Use the following steps:- *open excel *select full sheet using ctl+A *right click and then select "Format cells" *click on "number" and then reduce decimal points to "0" and then clic Ok Hope ur work will be done.
08 August 2012
Hello Go to > TOOLS & OPTIONS (as per your windows version) > Editing Options > Automatically Insert a decimal point > Remove tick/tag for this option > Or press F1 and Serch for automatically insert decimal point
CAclubindia
