S
SS
I have selected a column, choose Format, Cells, Special, Zip Code, but some
of the cells continue to show up in error checking as "text". The
spreadsheet is thousands of rows long, and I do not want to have to go
through every single error to change text to number or zip. Why is the
formatting not changing all cells? (I am copying & pasting the rows that
have name/address/zip from another Excel spreadsheet I have - but I have
changed the formatting on the zip code column to zip code in that spreadsheet
as well to no avail).
of the cells continue to show up in error checking as "text". The
spreadsheet is thousands of rows long, and I do not want to have to go
through every single error to change text to number or zip. Why is the
formatting not changing all cells? (I am copying & pasting the rows that
have name/address/zip from another Excel spreadsheet I have - but I have
changed the formatting on the zip code column to zip code in that spreadsheet
as well to no avail).