Date conversion issue "^" symbol

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Than Symbols and calculations 0
CSV->Excel Data Problem 1
Columns formatted As Dates Are Exported as a Number to Text 1
Date Conversion 3
Date to text conversion 1
Why can't I convert Long date format to Short date 1
Data being corrupted by excels automatic date recognition re-forma 6
converting date to text 2

Back
Top