software

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

custom format the number as 000000.--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: www.excelforum.com/member.php...oamp;userid=34322
View this thread: www.excelforum.com/showthread...hreadid=544387Use 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

quot;ctjakkalsquot; wrote:

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