|
How to set the value - 28 Nov?
Does anyone have any suggestions on how to set the value?
I would like to convert any number into 4 digit format. If there is a value 5 in cell A1, then it should return 0005 in cell B1 If there is a value 12 in cell A1, then it should return 0012 in cell B1 If there is a value 684 in cell A1, then it should return 0684 in cell B1 If there is a value 1365 in cell A1, then it should return 1365 in cell B1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
How to set the value - 28 Nov?
Enter =A1 in B1 and try custom formatting column B with format code "0000"!
It is only a display mode of the numbers. If you want strings, then enter in B1 =TEXT(A1,"0000") Regards, Stefi €žEric€ť ezt Ă*rta: Does anyone have any suggestions on how to set the value? I would like to convert any number into 4 digit format. If there is a value 5 in cell A1, then it should return 0005 in cell B1 If there is a value 12 in cell A1, then it should return 0012 in cell B1 If there is a value 684 in cell A1, then it should return 0684 in cell B1 If there is a value 1365 in cell A1, then it should return 1365 in cell B1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| All times are GMT +1. The time now is 07:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com