PC Review


Reply
Thread Tools Rate Thread

Date in cell

 
 
Annette
Guest
Posts: n/a
 
      25th Jun 2008
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 With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      25th Jun 2008
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.

 
Reply With Quote
 
Kevin B
Guest
Posts: n/a
 
      25th Jun 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter date in one cell, and the week ending date [Sunday] appears inthe "W/E" cell Tonso Microsoft Excel Discussion 3 26th Aug 2011 02:47 PM
Excel 2003 make 1 date cell automatically change another date cell Scotty Microsoft Excel Worksheet Functions 3 22nd Apr 2010 06:15 AM
date in Cell to change colors if the date is beyond today's date Pete Elbert Microsoft Excel Misc 2 6th Jun 2009 06:31 AM
comparing abr. Date Text cell to a date formatted cell David B Microsoft Excel Programming 0 24th Apr 2008 05:46 PM
Click on cell-calendar drops down-click on date-date fills cell. . =?Utf-8?B?R2Vvcmdl?= Microsoft Excel Setup 1 15th Apr 2005 08:22 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:13 AM.