Suppose cell A1 contains numeric value of 1.
You want to customize cell A1 to display 0001:
give the cell a custom format of 0000.
You want to convert it to character value of 0001 on cell B1:
type in cell B1 --> =REPT(0;4-LEN(A1))&A1
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment