| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Numbers Converted to Text - Last Digit Replaced by Zero
I have an account number of 941 486-1072 041025 in text format.
Need to remove spaces and dashes for a continuous data string. Tried using find/replace to remove spaces and dashes and it works - *almost* The problem is that the last digit of 5 is replaced by a 0 (zero) and shows as 9414861072041020 Any suggestions? Other than manually editing each cell, that is? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| excel - numbers as text | New Users to Excel | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Threaded Mode
