Changing a cells format

[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?

 

[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

 

[Brent Hauver]

Thanks Julie D! That did the trick

 

[JulieD]

Hi Brent

you're welcome and thanks for the feedback.

Cheers
JulieD