ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   numbers not correct (https://www.excelbanter.com/new-users-excel/176635-numbers-not-correct.html)

Chicken Dogs[_2_]

numbers not correct
 
When I try to add numbers to a cell, they are converted to a date. How can I
correct this? I have the "general" numbers tab selected. (Excel 2007)

Max

numbers not correct
 
Think you could either precede the entry with an apostrophe ('), or
pre-format the data entry col as text.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chicken Dogs" wrote:
When I try to add numbers to a cell, they are converted to a date. How can I
correct this? I have the "general" numbers tab selected. (Excel 2007)



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

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