Strange Excel Problem need help with..

Giganews Newsgroups
Subject: Strange Excel Problem need help with..
Posted by:  KHRS (kris.crispe…@gmail.com)
Date: 1 Jan 2007

I have an excel sheet with dates in a row of cells (example 06/14/2004)
when i click on the any cell with a date; as you know the data is also
displayed up in the formula bar. But the date up in the formula bar has
a ' before it. (example '06/24/2004). That doesn't show up on the
sheet. Does anyone know why this is happening and also how to do a
batch edit to get the ' out of the dates. Ive tried a find and replace,
but the it doesn't see ' in the cells. Any help would be great.

Thanks

Replies