Formatting Dollar Amounts
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Formatting Dollar Amounts

  1. #1
    Guest

    Default

     
    What's the best way to remove the non-numeric characters ($ , .) from a dollar amount, whil preserving the actual dollar amount.
    To be specific, I have a field which has dollar amounts of varying lengths (up to 12 characters), which need to be formatted so that just the numbers remain.
    The problem I've been running into, is the standard format commands either round the amount up and/or drop the last digit when it is a zero.
    For example, I need $156.80 to appear as 15680, and not 157 or 1568.

    Thanks.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This can't be done with formatting. Formatting doesn't alter the internal representation of values. If A1 contains 156.8 formatted as $156.80 you could get your desired value using =A1*100

    [ This Message was edited by: Mark W. on 2002-03-08 10:01 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    If all you have is dolalrs and cents, then
    you could try

    =TEXT(A1*100,"#00")

    to get what you want.
    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

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
  •  

 

 
DMCA.com