Prefix zero before digit

This query is : Resolved

Share Report Follow Query Ask a Query

Querist : Anonymous

Querist : Anonymous (Querist)

21 August 2014 How we can prefix Zero before Digit in Excel sheet=
e.g 95123
,095123
is wright .

Nikhil Kaushik

Nikhil Kaushik (Expert)
Follow

21 August 2014 right click on the cell ---->"Format Cells"--->"Custom"---Type 0,000,000.00

Querist : Anonymous

Querist : Anonymous (Querist)

21 August 2014 Dear sir i have applied this formula,but i can not add 0 before this digit.

Nikhil Kaushik

Nikhil Kaushik (Expert)
Follow

21 August 2014 its working fine at my system... alternatively, you set format to 0##,###,###,###.##

CA P K AGRAWAL

CA P K AGRAWAL (Expert)
Follow

21 August 2014 just put ' before the digits it will work

Nikhil Kaushik

Nikhil Kaushik (Expert)
Follow

21 August 2014 Agarwal Sir, that converts number into text and make computations impossible. that is why you need to format it as a number instead of text

CA P K AGRAWAL

CA P K AGRAWAL (Expert)
Follow

22 August 2014 Go for ignore error option in the cell then.

CA P K AGRAWAL

CA P K AGRAWAL (Expert)
Follow

22 August 2014 And what impact if it will be in text format, plz tell me

Nikhil Kaushik

Nikhil Kaushik (Expert)
Follow

22 August 2014 in "'" option, you will have to manually put ' in every cell. In format format option, the formatting can be applied to whole of the workbook, sheet, particular row or column in a second. So it saves time.

CA P K AGRAWAL

CA P K AGRAWAL (Expert)
Follow

22 August 2014 oh ok no technical problem time problem

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

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

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

bhavesh

Rajat Khandelwal

ashok jain

Devaraj B V

Konijarala prasad

Subscribe Now

Prefix zero before digit

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA