E
Erin
Hi All,
Is there a way to keep Excel from turning text that might
represent a date into a date? For instance a user is
entering text such as june20, march08. If we format the
cells as text before entering it is fine until he tries to
use the Replace feature. During the Replace process Excel
overrides the text formatting. Is there anyway to turn
this off? We forced it with an apostrophe, but that seems
like a sloppy fix. Any suggustions would be appreciated.
Thanks.
Erin
Is there a way to keep Excel from turning text that might
represent a date into a date? For instance a user is
entering text such as june20, march08. If we format the
cells as text before entering it is fine until he tries to
use the Replace feature. During the Replace process Excel
overrides the text formatting. Is there anyway to turn
this off? We forced it with an apostrophe, but that seems
like a sloppy fix. Any suggustions would be appreciated.
Thanks.
Erin