When I use Excel to manipulate my IT glossary, I sometimes wind up with entries that inadvertently get changed, and I'm not sure why. I know it has to do with cell format, but I can't seem to get it right.

For example, e3h = every 3-4 hours gets changed to "every 4-Mar hours."

Why does it change my text to a date format? I thought I had formatted the cells as "general." Do I need to simply format the entire spreadsheet as "text?" I tried the Excel help files and it didn't seem to clarify what seems to be a fairly basic concept that I just can't seem to grasp!

Thanks in advance!
sono_io

Yes, format the cells as text to assure numbers won't automatically turn into dates.

Wow, Cheryl! That was quick!

Thanks for the help! I could've sworn I tried it as both text and general, and got the same results. Anyway, I'll give it a try and see what happens!

Thanks again!
-sono_io

Looks like we were both "live" at the same time. You're welcome.

Just remember that if you want to use a formula in a cell, you need that cell formatted as General rather than Text.