| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Fractional Numbers as Numbers NOT Date | Excel Worksheet Functions | |||
| how do i enter numbers starting with zero in excel | Excel Discussion (Misc queries) | |||
| how to enter telephone numbers in Excel sheet | Excel Discussion (Misc queries) | |||
| How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
| I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
Linear Mode
