Hello. I routinely have to move text to columns leaving the alpha characters in the first column and moving the number to the second column: MAT001. When I do this the leading zeros disappear. I have already made all the cells text, but that doesn't work. Any ideas, please? TX!
I was absolutely not offended at all. I have to remind people to turn the caps lock off in their emails all the time.
Radu, my "edit directly in cell" box is checked. I think I'm just going to have to be extremely careful when double clicking in a cell. Bummer!!! But thank you so much...
Oops, Chandoo, I use caps for headers all day & forget it's lousy email etiquette. I wasn't actually SHOUTING my subject title. I'm sure that double click to the bottom of the column is very handy, but for me, it drives me nuts. Is there a way to turn it off?
Tx, SMD
Hi. I work with spreadsheets all the time, manipulating data in cells. How do I turn OFF the jump to bottom of column? It becomes a bit of a nuisance, when I'm working on a 4,000 line spreadsheet. THANKS1