=RAND()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Word to document some Excel spreadsheets. In Excel
=RAND()
is a valid formula. When I enter this my my document, Word converts it into
gibberish.


How do I disable this feature?
 
I made an experiment and found a method that seems to disable - or maybe
rather replace - the “featureâ€: I created an AutoCorrect entry (Tools >
AutoCorrect options) and entered “=rand()†in both the “Replace†and “Withâ€
fields.

However, I you want to be able to enable the “feature†again, you may not
want to use that method - it seems as if it is gone even if the AutoCorrect
entry is deleted (so who knows, I may regret that I tried...).

--
Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word


Gary''s Student said:
Thank you Luc for your assisstance.

While the link did not explain how to disable this feature it suggested a
good work-around
Click to expand...
 
Thank you for your help. I'll take your advice. If I loose the "feature"
forever, I will not cry.
 
For me it seems to suffice to just press Ctrl+Z (Undo) after "=RAND()" is
converted to quick brown foxes.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
My first attempt was also to use Ctrl+Z. For me it did also undo the
conversion but the quick brown fox always appeared again as soon as I
continued typing (I tested it on two computers with different Word versions).

--
Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word
 
I can type =rand() and continue typing with no problem. It's only pressing
Enter that causes the problem. And if you need a paragraph break following
=rand(), you can type something after it, go back and press Enter, then
Ctrl+Z, then start up again at the end of what you typed. I agree that this
would be a nuisance, so it's not really a satisfactory workaround.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Hi Lene,

This didn't work for me in Word 2003 using either the plain or formatted entries in Autocorrect. If you unchecked the Autocorrect
option to [x] Replace text as you type, that could disable the
=rand() replacement, but also the rest of the autocorrect entries as well.


==================
I made an experiment and found a method that seems to disable - or maybe
rather replace - the "feature": I created an AutoCorrect entry (Tools >
AutoCorrect options) and entered "=rand()" in both the "Replace" and "With"
fields.

However, I you want to be able to enable the "feature" again, you may not
want to use that method - it seems as if it is gone even if the AutoCorrect
entry is deleted (so who knows, I may regret that I tried...).

--
Regards
Lene Fredborg >>
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
 
As others have indicated there is no way to disable the feature.

As far as I know the dummy text is only inserted when entering a paragraph
mark (pressing Enter) and then only when the complete paragraph is "=RAND()"
optionally surrounded by white space (spaces, non-breaking spaces and tabs).
I would think it pretty unusual - even when documenting Excel functions -
for this to happen unintentionally, and on the occasions that it does, it
can be undone very easily.

As a rule, if anything unexpected happens to me in any application, pressing
Ctrl+Z is the first thing I try - 'I didn't want that, please undo it'. In
this case that would have been all that was needed; a fairly minor
inconvenience at worst, wouldn't you say?
 
I may have been infected with all those quick brown foxes and lazy dogs
yesterday ;-)

Today, all was back where I started yesterday and nor could I get the
AutoCorrect to work as I experienced and described yesterday (I did not
deselect “Replace text as you type†yesterday). So now I am sure I was wrong
about AutoCorrect - I am really sorry.

--
Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word
 
We all have those days--things work that don't work the next day and vice
versa.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Lene Fredborg said:
I may have been infected with all those quick brown foxes and lazy dogs
yesterday ;-)

Today, all was back where I started yesterday and nor could I get the
AutoCorrect to work as I experienced and described yesterday (I did not
deselect “Replace text as you type†yesterday). So now I am sure I was wrong
about AutoCorrect - I am really sorry.

--
Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word


Bob Buckland ?:-) said:
Hi Lene,

This didn't work for me in Word 2003 using either the plain or formatted entries in Autocorrect. If you unchecked the Autocorrect
option to [x] Replace text as you type, that could disable the
=rand() replacement, but also the rest of the autocorrect entries as well.


==================
I made an experiment and found a method that seems to disable - or maybe
rather replace - the "feature": I created an AutoCorrect entry (Tools >
AutoCorrect options) and entered "=rand()" in both the "Replace" and "With"
fields.

However, I you want to be able to enable the "feature" again, you may not
want to use that method - it seems as if it is gone even if the AutoCorrect
entry is deleted (so who knows, I may regret that I tried...).

--
Regards
Lene Fredborg >>
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
Click to expand...
Click to expand...
 
...and some of us have things that don't work on *any* days...:-(

Suzanne S. Barnhill said:
We all have those days--things work that don't work the next day and vice
versa.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

Lene Fredborg said:
I may have been infected with all those quick brown foxes and lazy dogs
yesterday ;-)

Today, all was back where I started yesterday and nor could I get the
AutoCorrect to work as I experienced and described yesterday (I did not
deselect "Replace text as you type" yesterday). So now I am sure I was wrong
about AutoCorrect - I am really sorry.

--
Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word


Bob Buckland ?:-) said:
Hi Lene,

This didn't work for me in Word 2003 using either the plain or
formatted entries in Autocorrect. If you unchecked the Autocorrect
option to [x] Replace text as you type, that could disable the
=rand() replacement, but also the rest of the autocorrect entries as well.


==================
I made an experiment and found a method that seems to disable - or
maybe
rather replace - the "feature": I created an AutoCorrect entry (Tools >
AutoCorrect options) and entered "=rand()" in both the "Replace" and "With"
fields.

However, I you want to be able to enable the "feature" again, you may not
want to use that method - it seems as if it is gone even if the AutoCorrect
entry is deleted (so who knows, I may regret that I tried...).

--
Regards
Lene Fredborg >>
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
Click to expand...
Click to expand...
Click to expand...
 
True.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Aalaan said:
..and some of us have things that don't work on *any* days...:-(

Suzanne S. Barnhill said:
We all have those days--things work that don't work the next day and vice
versa.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

Lene Fredborg said:
I may have been infected with all those quick brown foxes and lazy dogs
yesterday ;-)

Today, all was back where I started yesterday and nor could I get the
AutoCorrect to work as I experienced and described yesterday (I did not
deselect "Replace text as you type" yesterday). So now I am sure I was wrong
about AutoCorrect - I am really sorry.

--
Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word


:

Hi Lene,

This didn't work for me in Word 2003 using either the plain or
formatted
Click to expand...
entries in Autocorrect. If you unchecked the Autocorrect
option to [x] Replace text as you type, that could disable the
=rand() replacement, but also the rest of the autocorrect entries as well.


==================
I made an experiment and found a method that seems to disable - or
maybe
rather replace - the "feature": I created an AutoCorrect entry (Tools
AutoCorrect options) and entered "=rand()" in both the "Replace" and "With"
fields.

However, I you want to be able to enable the "feature" again, you may not
want to use that method - it seems as if it is gone even if the AutoCorrect
entry is deleted (so who knows, I may regret that I tried...).

--
Regards
Lene Fredborg >>
--

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
Click to expand...
Click to expand...
Click to expand...
 
Back
Top