Number Zero not displaying

[adrian078]

I have a file with some postcodes that start with the number zero. Each time I try to use a formula the zero is not shown in the result. I tried reformatting but can't find how to do this.

E.g. Cell A1 = "0800"
I use a formula B1 = A1 I get the result "800" instead of "0800"

Any ideas how to format it so it does show? The finished file needs to be CSV format.

 

[sanrv1f]

Include a single quote mark (') at the begninning or change the cell format to "0000"

 

[Useful]

Hi
First select the cells that you want to change format, press Ctrl+1 then choose Text and then try tipe your numbers (or press F2 if you have entered values before)

 

[Peter_SSs]

I have a file with some postcodes that start with the number zero. Each time I try to use a formula the zero is not shown in the result. I tried reformatting but can't find how to do this.

E.g. Cell A1 = "0800"
I use a formula B1 = A1 I get the result "800" instead of "0800"

Any ideas how to format it so it does show? The finished file needs to be CSV format.

If the values are always 4 digits the try
=TEXT(A1,"0000")

If the number of digits can vary then try
=LEFT(A1,LEN(A1))