LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

Excel

Vandana (Student) (70 Points)

27 April 2013

when i type numbers in excel the last two digit goes to decimal. for example if i type "5555", the value given is "55.55". what is the problem and give me a solution.

Reply
Follow
Share

6 Replies

V Vara Prasad (Chartered Accountant) (212 Points)
Replied 27 April 2013

Can u upload that excel file

I want see that and I will tell if i find any solution

Kaushik (Professional) (549 Points)
Replied 28 April 2013

Originally posted by : Vandana
	when i type numbers in excel the last two digit goes to decimal. for example if i type "5555", the value given is "55.55". what is the problem and give me a solution.

Check the setting you have entred for decimal point in options.

Excel-2003

Click on Tools>option>Edit>unchecked Fixed Decimal.

CA Parveen Jain (Chartered Accountant ) (355 Points)
Replied 28 April 2013

Originally posted by : Kaushik

Originally posted by : Vandana

when i type numbers in excel the last two digit goes to decimal. for example if i type "5555", the value given is "55.55". what is the problem and give me a solution.

Check the setting you have entred for decimal point in options.

Excel-2003

Click on Tools>option>Edit>unchecked Fixed Decimal.

CA Saroj Kumar (Keen to learn something new every moments) (2588 Points)
Replied 28 April 2013

right click on cell -> format-> number

change decial

or change format of cell

Slelect..all ..CRTL+A

and then change cell format by right clcicking.

Mathew Tharakan (Executive IT Department) (21 Points)
Replied 29 April 2013

I have also a problem of decimal point, Thanks for your help

VEDANTA DESHIKA (Practice) (317 Points)
Replied 01 May 2013

Microsoft Excel is the most common used Spread Sheet program. Any person who has an interaction with computer uses the Excel. Almost everyone who uses the computer in Home or Office knows the basic Excel function like Sum, Minus, Division etc.

However most of the people are still unaware of the wonders that Excel can do. Data analysis is the next big business and Excel is playing a bigger role in it. In fact most of the Data analysis is done using Excel by small firms. And recent dynamic changes in Business world have reduced the demand of Accountant and now the Businesses need Analytants. Analytants is not the standard word but I prefer to use it. In present time being an accountant is not enough and one has to be good analysis expert too.

It is not just the Accountant that need to have the analysis skill but also other professional whether they working in Sales, purchase, inventory or any other department.

I would like to mention a real situation which I faced. I was appointed as an Accounts Consultant in a company, and the first thing I was supposed to do was to find the discount Applicable to different buyers. It was a huge data and if it was to be done manually or using the simple Excel Functions, I would have taken more than a week. But with the help of Advance Excel formulas I could finish the work within a day. Continue...