Date conversion issue "^" symbol

S

Shannon

I receive a weekly file from a tool that sometimes throws a "^" character in
front of date. This symbol seems to be throwing excel off and I am unable to
convert the date into number format. Excel treats the cells that begin with
"^" as text.

Oddly enough in another part of the workbook I use the IF function to
compare the start date and end date of a project. Although I am unable to
convert the dates to number format the formula works.

Has anyone run into issues with the "^" character preceding a date? And if
so, how do I fix?
 
A

Alan

Just a guess as you dont say where the file is coming from. As ^ is only
used for roots, try highlighting all the data in the file and using 'Edit'
'Replace' 'Replace What' ^ 'Replace With' Nothing > Replace All
 
Top