Changes in Value!

[ng6971]

Hi All,

I have some data in following manner:

Col. A
0101
0201
0301
0901
1001

It will show as in formula bar:

Col. A
101
201
301
901
1001

Results needed as shown in blue colour in formula bar and also in any column to putting the formula =A2.

Col. A
0101
0201
0301
0901
1001

Thanks in advance.

 

[VoG]

If you don't need to use the numbers in calculations, perhaps

=TEXT(A2,"0000")

 

[ng6971]

Thanks VoG. It works.