How can I display control characters in Excel 2007?

B

Bungle

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

Now
 
H

Héctor Miguel

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

Now ...
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an option to view Special (control) Characters in Excel 2 3
Show or Hide control characters in a cell (using Excel 2007)... 0
Display or hide control characters in Excel 2007 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Viewing Control Characters 3
Set max characters in cell (Excel 2007) 4
How many characters in text box in Excel 2007? 1
change direction worksheet excel 2007 right to left 9

Top