ENTERING DATA IN CELL

DORISA · May 15th, 2002, 12:46 PM

When I entered data in a cell, the data that I typed appeared twice in the worksheet but only once in the formula bar. I am adding a name; last, first to an existing list of names in the same column. The other names appear as they were typed. I checked formatting but can't find what would cause this to happen. If I insert a leading apostrophe after spacig four times, the data appears as typed.

Mark W. · May 15th, 2002, 12:57 PM

How is the cell formatted? Is the format somewhat like...

;;;@ @

DORISA · May 15th, 2002, 01:04 PM

There is no formatting in the cell or the formula bar at the top. The cell only contains letters, i.e last name, first name.

Mark W. · May 15th, 2002, 01:34 PM

When you choose the Format | Cells... menu command and click on the Custom category what do you see in the Type field?

DORISA · May 15th, 2002, 01:37 PM

GENERAL

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 12:46 PM	#1
DORISA New Member Join Date: May 2002 Posts: 6	When I entered data in a cell, the data that I typed appeared twice in the worksheet but only once in the formula bar. I am adding a name; last, first to an existing list of names in the same column. The other names appear as they were typed. I checked formatting but can't find what would cause this to happen. If I insert a leading apostrophe after spacig four times, the data appears as typed.

May 15th, 2002, 12:57 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	How is the cell formatted? Is the format somewhat like... ;;;@ @

May 15th, 2002, 01:04 PM	#3
DORISA New Member Join Date: May 2002 Posts: 6	There is no formatting in the cell or the formula bar at the top. The cell only contains letters, i.e last name, first name.

May 15th, 2002, 01:34 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	When you choose the Format \| Cells... menu command and click on the Custom category what do you see in the Type field?

May 15th, 2002, 01:37 PM	#5
DORISA New Member Join Date: May 2002 Posts: 6	GENERAL