Excel - '000

This query is : Resolved

Anil (Querist)
Follow

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,

CA Suresh Choudhary

CA Suresh Choudhary (Expert)
Follow

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.

Anil

Anil (Querist)
Follow

15 April 2009 Thank you very much sir.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

Shantaveeresh Manur

AJAY Kumar Agrawal

RATI MALU

ASHOK KUMAR TEKURU

RISHI LATTA

Subscribe Now

Excel - '000

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

GST CONSULTANT

Accountant

CA Final

Senior Executive

GST CONSULTANCY

Manager- Finance and Compliance