Changing a cells format

B

Brent Hauver

I had some one type in some data for me and when I got it the cell box has a
Little green triangle in the top left hand corner- I assume that this means
it is a text format.

If double click on each cell it changes the format so I can do Sum etc.

But we are talking a lot of Data- Is there a way I can select the column
and change the format? Or do I have to use a formula in another column?
 
J

JulieD

Hi Brent

click in an unused cell (maybe even on another worksheet) and choose copy
now select the column(s) that you need to change and choose
edit / paste special and click ADD
click OK
they should all now change back to numbers

Regards
JulieD
 
Top