want all the fields in a column to be 9 digits
some numbers are
tried column change in microsoft excel 2007
but will not save because I need to convert to .csv
Click the [Number] tab if not already shown, & select the "Custom" Category.
For 9 digits, enter a Type of:
Confirm with the [OK] button.
PS. I note that your question asks for "9 digits" but you then state:
If you do want 14 digits, enter a Type of:
but this feature will not be preserved if I save as .csv