text in a cell upon entering the cell

B

Barb S

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

Thanks
Barb S
 
G

Gary''s Student

The double quote will appear if it is typed. If you type two single quotes
(apostrophes), only one will appear.
 
B

Barb S

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?
 
R

RagDyeR

Select your cells, say A1 to A100, then:
Try "Data Validation" with this custom formula:

=LEFT(A1)=""""


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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?
 
Top