Excel worksheet

This query is : Resolved

Ambrish (Querist)
Follow

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

Pankaj Gupta

Pankaj Gupta (Expert)
Follow

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.

Pankaj Gupta

Pankaj Gupta (Expert)
Follow

Ambrish

Ambrish (Querist)
Follow

07 August 2012 Dear Pankaj,
Thanks!
I have done as suggested but its the same,problem not resolved.
regds
Ambrish Gupta
9457078644

Nachiket Vasantgadkar

Nachiket Vasantgadkar (Expert)
Follow

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

Hope this will work

Ambrish

Ambrish (Querist)
Follow

08 August 2012 Hi Nachiket,

Thanks indeed, it works
Best regards,
Ambrish

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now