Date in cell

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

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.
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match Dates in Two Cells and Ignore subsequent Cells 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Finding a sum by matching two cells with the same identifier 1
Sumif comparing dates in criteria 1
Sum Totaled based on Matching Identical Criteria in Worksheet 1
List multiple values in seperate cells 7
Help to create a macro 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top