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
- Applicability
- Is Aadhar PAN linking required for opening bank account?
- Where to show the RCM on Rent paid to unregistered landlord
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- Application of 115BAC
- RCM - commercial rent paid to URP under GST
- Offsetting interest income against derivative trading losses
- TDS NUMBER SURRENDER
- GSTR-3B - Do I file nil when there is no sale but I've bought raw materials
- Legal heir raised refund , but refund issued to the closed account of deceased.
- Whether still royalty
- 20% OF DEMAND PAYMENT IN APPEAL
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- 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 Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
