ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using a Decimal changes cell to a label (https://www.excelbanter.com/excel-programming/292885-using-decimal-changes-cell-label.html)

Adam Cheslsin

Using a Decimal changes cell to a label
 
Using a Decimal changes cell to a label

If I use a decimal in a cell, it changes the cell to a label. I must
put a "+" or "-" before I enter the number. I have tried formatting
the sheet and cell still changes to label. I have also tired
reinstalling the programs no change. Any ideas?

Vasant Nanavati

Using a Decimal changes cell to a label
 
See one possible answer to your other posting.

--

Vasant

"Adam Cheslsin" wrote in message
om...
Using a Decimal changes cell to a label

If I use a decimal in a cell, it changes the cell to a label. I must
put a "+" or "-" before I enter the number. I have tried formatting
the sheet and cell still changes to label. I have also tired
reinstalling the programs no change. Any ideas?





All times are GMT +1. The time now is 03:19 AM.

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