Prefix zero before digit

Save Share

Join Us Follow Us Add as Source

This query is : Resolved

Report 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)

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)

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

CA P K AGRAWAL

CA P K AGRAWAL (Expert)

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

Nikhil Kaushik

Nikhil Kaushik (Expert)

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)

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

CA P K AGRAWAL

CA P K AGRAWAL (Expert)

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

Nikhil Kaushik

Nikhil Kaushik (Expert)

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)

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