How to set the value - 28 Nov?

E

Eric

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
 
S

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set the value? 6
How to set the formula (26 Nov)? 3
How to do it in excel? 4
How to set the formula? 4
How to change the year digit? 4
How to retrieve the value within string? 10
How to select the value? 2
How to find the number? 7

Top