ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hidden Characters (https://www.excelbanter.com/excel-programming/420027-hidden-characters.html)

Gene Mills

Hidden Characters
 
How can I turn off hidden characters in either the options box or using vba
so they are visible. I want to be able to see the ' as the first character
in the cell

Thanks
Gene



Dave Peterson

Hidden Characters
 
In xl2003 menus:

Tools|Options|Transition Tab|Turn "Transition Navigation keys" on

If you want code, you can record a macro when you do it manually.

Gene Mills wrote:

How can I turn off hidden characters in either the options box or using vba
so they are visible. I want to be able to see the ' as the first character
in the cell

Thanks
Gene


--

Dave Peterson


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com