This question already has an answer here:
- Excel: copy cell formatting in equation 5 answers
I have been looking all over the internet for this question, but it has not been answered by anyone.
I am, on Excel 2010, trying to copy (not copy and paste) the format AND value of a cell, onto another cell.
I'm trying to copy my formatted cell (AE1) onto another cell (O3). I have tried to use the
=AE1 function, but it only copies the text. I want the format and the value to be copied however.
All help will be appreciated. :)
Just a note, I am not copy and pasting. :)