ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2000 Text (https://www.excelbanter.com/excel-worksheet-functions/75002-excel-2000-text.html)

Sabrina

Excel 2000 Text
 
I am trying to add an i in one of the rows and it changes it over to an I
capital and I change the formatting to Text and have tried everything I can
think of and I can't get excel to leave the text that I want place in. Which
is i

If anyone knows why this is happening please e-mail me, Thank You

Bob Phillips

Excel 2000 Text
 
If you go to ToolsAutocorrect... and you will see a box 'Capitalize first
letter of sentence' that is checked. Uncheck it to get what you want.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sabrina" wrote in message
...
I am trying to add an i in one of the rows and it changes it over to an I
capital and I change the formatting to Text and have tried everything I

can
think of and I can't get excel to leave the text that I want place in.

Which
is i

If anyone knows why this is happening please e-mail me, Thank You




Sabrina

Excel 2000 Text
 
Hi Bob,

THANK YOU !!!
This corrected the problem. I had to uncheck all the boxes, but it worked.

Sabrina

"Bob Phillips" wrote:

If you go to ToolsAutocorrect... and you will see a box 'Capitalize first
letter of sentence' that is checked. Uncheck it to get what you want.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sabrina" wrote in message
...
I am trying to add an i in one of the rows and it changes it over to an I
capital and I change the formatting to Text and have tried everything I

can
think of and I can't get excel to leave the text that I want place in.

Which
is i

If anyone knows why this is happening please e-mail me, Thank You






All times are GMT +1. The time now is 09:00 PM.

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