Forum Discussion
How do I keep "text" style when globally replacing dates in Excel?
I keep a monthly log of electric meter readings in Excel. I track readings by date, and the first column is simply: 01/01 01/02 01/03 etc. Since the default style automatically changes eac...
OK, I found the forgotten shortcut. Just type an apostrophe at the beginning of a number string and it will display as text, and stay that way even when you copy and paste. Problem solved.