Does anybody know how to remove the leading tilde when entered into a cell in excel?
ie. cell says ~31-FEB-04 but I want the numeric format of the date.
Find and replace does not work, and =+RIGHT(B1,LEN(B1)-FIND("~",B1)) is just tedious.
Any suggestions gratefully received,
MIke