#1   Report Post  
reneabesmer
 
Posts: n/a
Default AutoCorrect

Hi...
i have a problem that i want to share it with u people. it is about
AutoCorrect.
Suppose when i write " Potat" so it change to " Potato"
but when i use it like it. where cell a2=potato
=left(a2,len(a2)-1)
so i get the result "Potat" which don't change automatically to "Potato"
i need the help................. plz
Email me plz at :-
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Autocorrect will only work on typed in text entries, not formula

--
Regards,

Peo Sjoblom


"reneabesmer" wrote in message
...
Hi...
i have a problem that i want to share it with u people. it is about
AutoCorrect.
Suppose when i write " Potat" so it change to " Potato"
but when i use it like it. where cell a2=potato
=left(a2,len(a2)-1)
so i get the result "Potat" which don't change automatically to "Potato"
i need the help................. plz
Email me plz at :-



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time format help needed Dan W. Excel Worksheet Functions 19 March 6th 08 09:08 AM
AutoCorrect reneabesmer Excel Worksheet Functions 0 April 19th 05 04:48 AM
how to turn on and off autofill feature in 2000 Spudd Excel Discussion (Misc queries) 4 March 12th 05 02:57 PM
HOW TO TRANSFER AUTOCORRECT DICTIONARY TO NEW COMPUTER?? ALAN K Setting up and Configuration of Excel 1 February 17th 05 09:34 PM
COPYING AUTOCORRECT DICTIONARY TO NEW COMPUTER ALAN K Excel Discussion (Misc queries) 1 February 17th 05 12:34 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"