Social Security Number contains invalid information

The entered Social Security Number contains invalid information? I didn't enter a Social Security Number. I selected the option for USAA Number and entered that. How am I to correct invalid information I did not enter?

@PWalshWFDI: "Names can only contain low-ASCII letters and numbers cannot begin with a number." what an error message.



I assume "low-ASCII" refers to the 7-bit ASCII characters. However, users shouldn't be expected to know what this means.

Or maybe low-ASCII refers to lower case. Sorry, you must break with convention and not capitalize names.

Can a number begin with a number? What if my name is "7" or "8"? ;)

Excel treats numbers like text

Sherry Chupka reports:

I loaded a CSV file into Excel 2007 and noticed some of the cell outlines were missing. 

I copied the value 3045.45 to enter it in a bug report. After that the value was no longer aligned and some of the cell outlines to the right are missing. 

I loaded the file in another editor and found out there are spaces at the end of each record. 

Seems that when I copied the numeric value Excel automatically changed the format of that cell from text to numeric and removed the trailing spaces. There are 3202 rows in this file. Does that mean I have to copy the last value on all the rows? Then I formatted the column using Format Cells. Why doesn’t Format Cells remove the trailing spaces? 

Maybe it should ask if you want to remove spaces. The trailing spaces were only removed from the cells where I copied the numeric portion of the value. I guess Excel doesn’t like spaces after a numeric value.

---

Ben Simo adds:

Numbers entered or imported into Excel are often treated as text.  Changing the display format generally doesn't make any difference in whether data is treated as text or numbers.

This often creates problems. Microsoft is aware of this and addresses it in the help.  The Excel 2003 help states "Occasionally, numbers may be formatted and stored in cells as text, which later can cause problems with calculations or produce confusing sort orders."

So, what can we do about this without manually editing thousands of data cells?  If we perform math on the cells, Excel will change the values to numbers.  The easiest way I've found to handle this is to either add zero to all the cells, or multiply all the values by one.  This can be done by using the Paste Special feature.

By adding 0:

1. Enter a value of 0 into a blank cell.
2. Select the cell with the value 0, and copy the cell to the clipboard
   
3. Select the numeric cells that Excel is treating as text
4. Select Paste Special
5. Select Add
6. Click OK to add 0 to the selected cells.

By multiplying by 1:

1. Enter a value of 1 into a blank cell.
2. Select the cell with the value 1, and copy the cell to the clipboard
   
3. Select the numeric cells that Excel is treating as text
4. Select Paste Special
5. Select Multiply
6. Click OK to add 0 to the selected cells.

Yes, there is a problem here. There is a fix but is isn't very obvious.

The number must be between 1 and 45

I configure Microsoft Word to format text I selected as two evenly distributed columns.



After making my selections, I click the OK button in the Columns configuration window.




I get an error.

What number must be between 1 and 45? What number on this form is not between 1 and 45?

Password rules

“there are so many things wrong with this error message” - @MichaelHartnett