Format Number in A Cell

[kkocak]

yea, so easy problem probably.....

but i want to apply a formatting stipulation to a column on a spreadsheet to format the numbers like "2007-132" and "2007-076"

The problem i am running into is getting the proper place holders in the right place....because i when i type 200776 i want it to appear "2007-076"...any ideas??

[Simon Lloyd]

You can do it via formula something like in column B:
=LEFT(A1,4) & "-" & RIGHT(A1,LEN(A1)-4)
then copy down all the values in column A will appear in column B as 2007-076 format.