Gary''s Student wrote:
Select the cells and then pull-down:

Format Cells... Number Custom and replace general with "programmable
controller" @
I have a spreadsheet with 2,608 rows, I need to enter the works "programmable
controller" in front the words already in each row. How could I do this
without having to enter in each row?

One point about this method, the contents of the cell is not changed, ie
you can't extract the "programme controller" part.

it will however print to hard copy

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200602/1