Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Currency Formatting Problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    For the life of me, I can not figure out how to give a currency format to a cell. I have used Format>Cells>Currency, but it is not showing the numbers correctly.

    I want to be able to type 12550 in a cell and have it appear as 125.50

    I do not want to type a decimal, and a dollar symbol would be lovely, but it's not necessary.

    Any help or suggestions would be appreciated!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I reckon the problem is that the Format>Cells>Currency is expecting you to type in dollars, whereas you're actually typing in cents.
    Why not type in your numbers 12250 in one column (say A) and in the column beside it divide it by 100 to create the decimal point
    =A1/100
    and then format that. Format>Cells>Currency will put it the dollar.

    Rgds
    AJ

  3. #3
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go to Tools/Options/Edit tab.

    Select Fixed decimals, set it to 2 and click ok to apply changes.

    Now if you type in 12550 without the decimal, it will show as 125.50, without having to divide it.

    Hope this helps,

    _________________
    Kristy

    "There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

    [ This Message was edited by: Von Pookie on 2002-04-12 09:04 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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