Excel - formatting issues

[jingleb]

I am getting little green marks on cells saying number
stored as text. When I try to format as special/social
security number, I can't figure out how to change a whole
column at once. I don't have time to double click on
7,000 items! Can anyone help? Thanks!

[null]

jingleb wrote:
> I am getting little green marks on cells saying number
> stored as text. When I try to format as special/social
> security number, I can't figure out how to change a whole
> column at once. I don't have time to double click on
> 7,000 items! Can anyone help? Thanks!

Highlight the entire column by clicking on the column letter at the top,
then do your formatting.

--
-the small one

All postings carry no guarantee or warranty, expressed or implied.
Proceed at your own risk, and perform system and data backups prior to
making changes to your system, and on a regular basis, to protect your
system.

[Don MacDougall]

"jingleb" > wrote in message
...
> I am getting little green marks on cells saying number
> stored as text. When I try to format as special/social
> security number, I can't figure out how to change a whole
> column at once. I don't have time to double click on
> 7,000 items! Can anyone help? Thanks!

news://msnews.microsoft.com/microsoft.public.excel.newusers

The above newsgroup is a good source of help for new Excel users.

If you click on the column letter, you will select the whole column. Then
you can use Format, Cells.

Don