| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
