ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   why "..." would interpret as "?" (https://www.excelbanter.com/excel-programming/393769-why-would-interpret.html)

rambino

why "..." would interpret as "?"
 
Anyone has ideas on how I could keep the value of a cell stay as

ALL...

Currently, it is interpreting it as

ALL?

Thanks!

RB Smissaert

why "..." would interpret as "?"
 
Have a look at Tools, Options, Spelling, AutoCorrect Options.

RBS

"rambino" wrote in message
...
Anyone has ideas on how I could keep the value of a cell stay as

ALL...

Currently, it is interpreting it as

ALL?

Thanks!



Jim Thomlinson

why "..." would interpret as "?"
 
You can check your auto correct settings. Tools - Options - Spelling -
Auto Correct
--
HTH...

Jim Thomlinson


"rambino" wrote:

Anyone has ideas on how I could keep the value of a cell stay as

ALL...

Currently, it is interpreting it as

ALL?

Thanks!


Vergel Adriano

why "..." would interpret as "?"
 
It seems when Excel encounters "..." it 'auto-corrects' it with the elipsis
character (#133 in the ANSI character table. See -
http://www.handheld-basic.com/docume...page_599.html). Perhaps the
font that you have selected does not support the display of that character.

To change the Auto Correct options, go to Tools-AutoCorrect Options.


--
Hope that helps.

Vergel Adriano


"rambino" wrote:

Anyone has ideas on how I could keep the value of a cell stay as

ALL...

Currently, it is interpreting it as

ALL?

Thanks!



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

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