Excel worksheet
This query is : Resolved
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
AK Gupta
Pankaj Gupta
(Expert)
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.
*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
(Expert)
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.
*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.
07 August 2012
Dear Pankaj,
Thanks!
I have done as suggested but its the same,problem not resolved.
regds
Ambrish Gupta
9457078644
Thanks!
I have done as suggested but its the same,problem not resolved.
regds
Ambrish Gupta
9457078644
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
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
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Gst credit note by supplier
- Query on effect of registration of property
- Due date for filing return for the partner in partnership subjected to Tax Audit
- GST on reimbursement of expenses
- Missed uploading GST Invoice
- Equity Share Sale and Purchase
- Wrong CMPo8 file
- Goodwill transfer of deceased father’s firm – ICAI applying a 27.04.2026 cut-off to the 3 year limit
- Whether output tax is taken credit by purchaser
- Additional trade name
- Number of years as per AS amortisation of Goodwill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
