ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does date come up when I enter numbers in cell/Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/62608-why-does-date-come-up-when-i-enter-numbers-cell-excel.html)

Carol

Why does date come up when I enter numbers in cell/Excel?
 
I am working In Excel Office 2003. When I put a number or amount in a cell,
a date comes up each time. I have looked through alot of information and
can't seem to find out what causes this.

bpeltzer

Why does date come up when I enter numbers in cell/Excel?
 
Dates in Excel are just specially formatted numbers. So if you just change
the format, you should be okay. (Use one of the styles --comma, percent,
currency-- that you probably have on your toolbars or, from the menu bar,
Format Cells, select the number tab and choose an appropriate format).
HTH. --Bruce

"Carol" wrote:

I am working In Excel Office 2003. When I put a number or amount in a cell,
a date comes up each time. I have looked through alot of information and
can't seem to find out what causes this.



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

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