Hi everyone,
First time to this forum, was wondering how I can change a sequence of numbers from 1 - 100 in column A to read "(1%)" - "(100%)" in sequential order in column B without typing it out 100 times in text format. Excel does not recognize the text "(1%)" and so you can't just grab the box and drag it down 100 spaces.
Does anyone know a formula so that when you type the number 1 into a box, it will show the character (1%) brackets included?
Thanks,
Al
Bookmarks