text in a cell upon entering the cell
 

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

Thanks
Barb S

text in a cell upon entering the cell
 

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

text in a cell upon entering the cell
 

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

text in a cell upon entering the cell
 

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!
================================================== ===

"Barb S" wrote in message
...
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