Member Since: Sep 25th 2016
Hunter Research, Inc.
Jan 27th 2017
CONVERT CHASE TRANSACTION NUMBERS FROM TEXT TO NUMBERS:
I downloaded Bank Statement Data to Word & Excel. The deposits were calculateable currency. The payments were not. I tried the 3 tricks.
1. Tried all the tricks Internet showed
=isvalue(a3) True if text
=1 in column A2 copy past special multiply
Copy text number cells Data Text to Columns OK
NONE OF THESE TRICKS WORKED
2. Saved spreadsheet as anything.CSV
3. The opened anything.csv in a new Excel spreadsheet and found ?$500.00 for each value in the Payment column.
4. Replaced ?$ with $ which converted all text payments to currency to $500.00. QED.