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.
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...
Landmark Judgments: Important Provisions of the EPF & ESI Act interpreted by the Honorable Supreme Court of India
CAclubindia
