Thread: Format Issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Format Issue

I get a lot of files created from an accounting system that formats data as
"General". I want to format those columns that have numbers in them as
numbers. Generally, just clicking the "," icon will format the cells. But
if a cell has the "General" category, clicking the comma does nothing. I
have to change to General first. It is a pain. Does anyone know a quick
work-around?