Hi all,
I'm pretty new to Excels so forgive me if I don't make sense.
I'm filling in data on a spreadsheet, and I want to change the number 1, to the word Attended while I am filling in data.
I've tried to use IF and REPLACE formulas and conditional formatting, but obviously, typing data over the formulas means erasing it.
Again I apologise for my noobiness, but I am very stuck! Any help or ideas would be appreciated