Prefix zero before digit

This query is : Resolved

Report Abuse 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.

Upgrade to CAclubindia Pro. Subscribe Now!

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

Upgrade to CAclubindia Pro. Subscribe Now!

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