#1   Report Post  
Posted to microsoft.public.excel.misc
PJS PJS is offline
external usenet poster
 
Posts: 23
Default Text OTU

Hi, I am trying to enter OTU into an excel spreadsheet, but it automatically
changes OTU to OUT???

why is that?
Can anyone duplicate this and propose an idea how to get the cell just to
say OTU instead of OUT?

Thanks,

PJS
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 364
Default Text OTU

go to tools/autocorrect and remove the entry

--


Gary

"PJS" wrote in message
...
Hi, I am trying to enter OTU into an excel spreadsheet, but it
automatically
changes OTU to OUT???

why is that?
Can anyone duplicate this and propose an idea how to get the cell just to
say OTU instead of OUT?

Thanks,

PJS


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 364
Default Text OTU

forgot you may be using 2007. in that case, click the orb, excel options
button, proofing, and then autocorrect options
--


Gary

"PJS" wrote in message
...
Hi, I am trying to enter OTU into an excel spreadsheet, but it
automatically
changes OTU to OUT???

why is that?
Can anyone duplicate this and propose an idea how to get the cell just to
say OTU instead of OUT?

Thanks,

PJS


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Text OTU

Hi,

Too;s|Auto correct options

Type OTU in the Replace box and delete the entry

Note this is global for all of MS office so you lose this autocorrection in
WORD

Mike

"PJS" wrote:

Hi, I am trying to enter OTU into an excel spreadsheet, but it automatically
changes OTU to OUT???

why is that?
Can anyone duplicate this and propose an idea how to get the cell just to
say OTU instead of OUT?

Thanks,

PJS

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 793
Default Text OTU

If you do not want to turn AUTOCORRECT off for all mistakes, you can remove
the OTU entry from the autocorrect list...

Tools-AutoCorrect
On the first tab, at the bottom scroll down and select OTU and clcik delete
button.


"PJS" wrote:

Hi, I am trying to enter OTU into an excel spreadsheet, but it automatically
changes OTU to OUT???

why is that?
Can anyone duplicate this and propose an idea how to get the cell just to
say OTU instead of OUT?

Thanks,

PJS

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
using a conditional suffix in text function format syntax=text(value,format_text) Brotherharry Excel Worksheet Functions 1 January 13th 09 03:03 PM
Text does not display in "Text boxs" and when wrapping text in a c Esteban Excel Discussion (Misc queries) 1 March 8th 07 11:59 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
merged cells into one text cell, size varies dependant on text dat Jazzylady825 Excel Discussion (Misc queries) 0 December 9th 05 08:26 PM
convert a range of lowercase text to upper text or vice versa jackdaw Excel Worksheet Functions 2 May 16th 05 09:31 PM


All times are GMT +1. The time now is 01:10 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"