ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Working in Excel (https://www.excelbanter.com/excel-worksheet-functions/43688-working-excel.html)

tdarsey

Working in Excel
 
I am having trouble incerting the # 5 into a cell. It doesn't matter how I
format the cell of if I type in 5, 5., or 5.0 it shows "T" in the cell and if
I put in 5.5 it shows as "T.5". Does anyone have any ideas?

Dave Peterson

Look under tools|autocorrect options|autocorrect tab

I bet you have 5 being replaced with T.



tdarsey wrote:

I am having trouble incerting the # 5 into a cell. It doesn't matter how I
format the cell of if I type in 5, 5., or 5.0 it shows "T" in the cell and if
I put in 5.5 it shows as "T.5". Does anyone have any ideas?


--

Dave Peterson


All times are GMT +1. The time now is 04:28 AM.

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