ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I display control characters in Excel 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/240486-how-can-i-display-control-characters-excel-2007-a.html)

Bungle

How can I display control characters in Excel 2007?
 
In Excel 2003 this used to be set in:
Tools - Options - International - Show/Hide control characters.

Now

Héctor Miguel

How can I display control characters in Excel 2007?
 
hi, !

In Excel 2003 this used to be set in:
Tools - Options - International - Show/Hide control characters.

Now ...


try with vba, application.controlcharacters = true/false (although...)
this property can be settled only if there is installed and selected a language version configured from right to left

for the GUI you need an OS running right to left compatibility (i.e far east from WXP-SP2)
also, you need to enable that language (see online-help for office characteristics for writting right to left)
for you can see in the ribbon the available options for an specific language

(online-help is full of related information)

hth,
hector.




All times are GMT +1. The time now is 03:00 PM.

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