Lowercase text changed by Ecel to Uppercase after import

[John]

I opened a tab-separated list text file in Excel. One column had lowercase
text, which Excel converted to uppercase. Is there a way to control this.
Also how would I correct this in Excel

Thanks
John

 

[Rae Drysdale]

Possibly AutoCorrect (Tools menu). Uncheck capitalize first letter in
sentence. Is it just the first letter in the column or every word?

 

[John]

The file I am opening is as follows with a tab separating the 'true' from the
name
Sam Smith true
Will Smith true
etc...

and it opens in Excel like this
Sam Smith TRUE
Will Smith TRUE

I tried the Autocorrect settings (thanks) but this did not help.

Any other ideas?

 

[Dave Peterson]

When you see the wizard, you can tell excel to treat that column as Text
(instead of General).

 

[Dave Peterson]

Ps. If you don't see the wizard, you can rename the text file to *.txt, then
use file|open.

You'll see the wizard then.

 

[Gord Dibben]

John

Excel sees the word "true" or "false" and thinks it is the result of a formula
so changes to Upper case.

No way to prevent that without pre-formatting as text or preceding with an
apostrophe.

See Dave's suggestion about the Text import Wizard.


Gord Dibben MS Excel MVP