Need to add apostrophe to beginning of cell

Aaron · Apr 17, 2004

How can I shut off date autoformatting? I have a cell that I have to
enter the numbers "02-03" (no quotes), but Excel keeps turning it into a
date. How can I get around this? Setting AutoFormatting to None or
setting the cell type to General does nothing. Any ideas, anyone?

Thanks,
Aaron

Gord Dibben · Apr 17, 2004

Aaron

Your subject says it all. Add the apostrophe.

Alternate.....pre-format the cell(s) to Text before entering your data.

Gord Dibben Excel MVP

DAVE TAYLER · Apr 21, 2004

Enter a ' at the beginning.
( ' is under the @ on the keyboard).
This will make Excel think it's a string and not a date.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

Need to add apostrophe to beginning of cell

Aaron

Gord Dibben

DAVE TAYLER