I guess I didn't ask the question clearly. I have a spread sheet for
entering information. When other people enter information they forget to add
the " when they enter the cell before entering the rest of the text. All the
cells in this column should start with ". Is there a way to have Excel to
put it there auto or maybe to validate that it is there when the cell it
exited?

"Gary''s Student" wrote:

The double quote will appear if it is typed. If you type two single quotes
(apostrophes), only one will appear.
--
Gary''s Student


"Barb S" wrote:

I need to have " appear in a cell when it is entered. Does anyone know of a
way to do this?

Thanks
Barb S