ExcelBanter - How do I display 0 in eg 021796

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

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

- - How do I display 0 in eg 021796 - not as text? (https://www.excelbanter.com/excel-discussion-misc-queries/89887-how-do-i-display-0-eg-021796-not-text.html)

ctjakkals

How do I display 0 in eg 021796 - not as text?

How can I display the leading 0 in a number without having to change the cell
format to text? eg yymmdd 010115?

KellTainer

How do I display 0 in eg 021796 - not as text?

custom format the number as 000000.

--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544387

Peo Sjoblom

How do I display 0 in eg 021796 - not as text?

Use a custom format 000000

note that this will not be dates that excel can read without either using
vba or help formulas, to excel this will be ten thousand one hundred fifteen

Regards,

Peo Sjoblom

"ctjakkals" wrote:

How can I display the leading 0 in a number without having to change the cell
format to text? eg yymmdd 010115?

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