+ Reply to Thread
Results 1 to 2 of 2

How to stop converting dollar amounts to dates?

  1. #1
    Registered User
    Join Date
    09-15-2008
    Location
    Scranton, PA
    Posts
    1

    How to stop converting dollar amounts to dates?

    I am running Office 2000 with XP Home Edn. Today Excel started doing something weird. If I try to enter a column of figures for dollar amounts, any set of digits from one to twelve followed by a decimal point and two digits for cents is automatically converted into a calendar date, even if the date is impossible (for example, 11.39 becomes 39 November).

    I can prevent this by placing a "$" before each set of numerals, but if I do so, then AutoSum refuses to add them.

    How do I prevent the autoconversion from occurring in the first place?

    John H

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi,

    Take a look at this previous link - does that help?

    http://www.excelforum.com/excel-gene...ormatting.html
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. stop Excel from reformating my dates
    By LuAnn in forum Excel General
    Replies: 3
    Last Post: 12-07-2007, 11:22 PM
  2. Stop Excel Automatically Converting Dates?
    By doomalyas in forum Excel General
    Replies: 3
    Last Post: 11-19-2007, 03:25 PM
  3. How to display negative dollar amounts
    By greaseman in forum Excel General
    Replies: 2
    Last Post: 05-04-2007, 09:01 AM
  4. Converting Dates problem
    By fergusmacdonald in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2007, 02:00 PM
  5. Converting dates into months
    By debspecs in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-10-2007, 04:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1