lead zero are being dropped

**pfournier80** · 08-09-2012, 02:02 PM

Hello,
I have two columns that have numbers that begin with a 0. One column is zip codes and the other column is ID numbers(Most beginning with 0). I can see the zero on my end but when i email it to someone the zero disappears. Is there some formula or function that can be applied to these columns to keep the zeros from dropping?

**dilipandey** · 08-09-2012, 02:10 PM

HI pfournier80,

Format those two columns as Text and then try sending once...
Alternatively, you can prefix ' in zip codes and ID numbers to save them with starting zeros.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

---------- Post added at 11:40 PM ---------- Previous post was at 11:39 PM ----------

HI pfournier80,

Format those two columns as Text and then try sending once...
Alternatively, you can prefix ' in zip codes and ID numbers to save them with starting zeros.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Epscan** · 08-09-2012, 02:17 PM

Try changing cell format to text.

**pfournier80** · 08-09-2012, 03:49 PM

I tried to save them as text but when i do this the zero drops, I can see the zero on my end but its drops when emailed or drops on my end when i try and save them as text

**ChemistB** · 08-09-2012, 03:56 PM

In the next column dragged down

=TEXT(A2,"00000") assuming you want 5 digits. Then format your orignal cells as text and You can then copy and paste special back into the cells that you formatted as text.

**royUK** · 08-10-2012, 02:24 AM

Are you saving as csv?

**dilipandey** · 08-12-2012, 02:45 AM

yes.. please check what RoyUK has pointed out.

Please save workbook as xls or xlsx and then try once again. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>