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
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.
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
08 August 2012
Hi Nachiket,
Thanks indeed, it works
Best regards,
Ambrish
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- About TDS & Income Tax
- Scrutiny and reopening of past returns
- Under construction property in ITR
- PPF interest-As Exempt Income disclosure
- Pass word to open justification report for Q1 for FY 2026-27
- Section 194JA & JB Income which ITR Form to use
- Upload Level ValidationITR3Category of Defect B/D
- Booth for sales promotion
- Not able to file ITR
- Building tax payment deduction in rental Income
- VALUATION OF PRIVATE LIMITED COMPANY SHARES
- LIABILITY ADJUSTMENT
- Capital Gains on sale of residential flat
- Accounting with Claude
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
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
