Changing a cells format

  • Thread starter Thread starter Brent Hauver
  • Start date Start date
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?
 
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
 
Back
Top