Excel - '000
This query is : Resolved
15 April 2009
All the numbers in a coloumn are to be reduced to '000.
For example 12234 is to be reduced to 12.234 (i.e., twelve point two hundred thiry four)
How can I do it in one shot in excel?
Thanks,
For example 12234 is to be reduced to 12.234 (i.e., twelve point two hundred thiry four)
How can I do it in one shot in excel?
Thanks,
15 April 2009
Write 1000 in another cell, Copy that cell, select the entire area where you require to reduce, paste special then divide and enter.
I.e.
The 1000 Ctrl C, Alt ESV, Enter.
If Not Cleared you can call me 9892267054.
I.e.
The 1000 Ctrl C, Alt ESV, Enter.
If Not Cleared you can call me 9892267054.
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
Unanswered Queries
- Applicability of Books of Account for Commission Income (Sections 194D & 194H)
- Gst on travel by air for business purposes
- Loss of interest in PF transfer from EPFO to Trust
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- TDS offline utility
- TDS on rent received on hardship compensation being rent on redevelopment of building
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
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
