i'm sure this is a really simple issue...my knowledge of excel is not
comprehensive, it's all self-taught and very specific (i.e. i have a
great deal of knowledge on some stuff and other stuff i've never used).

i have a spreadsheet with five worksheets in it, and it's not letting
me type in any functions or alter the formatting of cells. essentially
the sticking point is there is a column of zip codes that has lost its
leading zero, and i'm trying to either concatenate it with a leading
zero or change the box format to zip code. no luck on either. if i type
in any formula, it just displays it in the box like regular text.

this spreadsheet has a few macros in it. is that what is causing the
issue? i've never worked with macros before, so my knowledge there is
essentially non-existent.

thanks for any and all help...
micah