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
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- TDS U/S. 194NF
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- ITC temporary reversal and reclaim
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- Applicable TDS rate for sale of property in Nov 2024
- GST ON EXPORT COMMISSION
- Should I report my US salary for January, February, March in Schedule FA?
- Inventory of finished goods
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
Trending Online Classes
CAclubindia
