Converting a Column of Cells using a formula to Text

[sophielane]

Hello

I have a column of data that was created using a formula.

I now need to make that just text, so in the bar above, when I click on the cell, I no longer see the formula but just the data.

thanks,
Babs

[Sam Capricci]

you can use copy then paste special >> values.

[dosydos]

copy data, paste values

[sophielane]

Thank you everyone!!!

[Sam Capricci]

sophielane, thank you for the rep! If your issue is solved please don't forget to mark the post as solved using the thread tools dropdown at the top of this post, the mods like things clean.