ExcelBanter - how do i show a zero in front of a number ie 0625 in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i show a zero in front of a number ie 0625 in excel (https://www.excelbanter.com/excel-discussion-misc-queries/111118-how-do-i-show-zero-front-number-ie-0625-excel.html)

George

how do i show a zero in front of a number ie 0625 in excel

I am trying to enter numbers in excel, and would like to see the 0 in front
of the number ie 0625

Gary''s Student

how do i show a zero in front of a number ie 0625 in excel

If you want numbers to show leading zeros for 4 digits then format the cells
as Custom 0000.

625 will display as 0625
1 will display as 0001

etc.
--
Gary's Student

"George" wrote:

I am trying to enter numbers in excel, and would like to see the 0 in front
of the number ie 0625

HaroldT

how do i show a zero in front of a number ie 0625 in excel

Thanks for the help - hjt

"Gary''s Student" wrote:

If you want numbers to show leading zeros for 4 digits then format the cells
as Custom 0000.

625 will display as 0625
1 will display as 0001

etc.
--
Gary's Student

"George" wrote:

I am trying to enter numbers in excel, and would like to see the 0 in front
of the number ie 0625

All times are GMT +1. The time now is 10:56 AM.