In Excel how can I add data to an existing cell? - TechRepublic
Question
July 13, 2011 at 11:09 AM
georgem5

In Excel how can I add data to an existing cell?

by georgem5 . Updated 14 years, 11 months ago

I have a row of cells that have a truncated zip code. For some reason this system truncates preceeding zeroes. I need a formula that will allow me to add a zero to the front of a 4 character cell. An example in J2 I have a 7075 which should be 07075. I tried looking at the Right-Mid-Left commands but I can only disply the contents of the cell I can’t get the zero to insert. Any help would be greatly appreciated.

This discussion is locked

All Comments