| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in cell
When I enter a dollar amount in a cell, a date appears. I must have done
something to cause this I have several previously used columns in which it did not happen, but it seems to want to continue past the columns on working on now too. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date in cell
Hi,
I sounds like your cells have become formatted as dates. Select the affected cells and format as general. Tools|Format|cells select general Mike "Annette" wrote: When I enter a dollar amount in a cell, a date appears. I must have done something to cause this I have several previously used columns in which it did not happen, but it seems to want to continue past the columns on working on now too. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date in cell
Select the cells you want to change to currency display and do the following:
Click FORMAT in the menu Select CELLS Click the NUMBER tab \Sselect the CURRENCY format. Click OK when done -- Kevin Backmann "Annette" wrote: When I enter a dollar amount in a cell, a date appears. I must have done something to cause this I have several previously used columns in which it did not happen, but it seems to want to continue past the columns on working on now too. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Hybrid Mode
