Format General Number to Currency
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Format General Number to Currency

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

    Default

     
    How can I format a General Number that was imported from a text file. The numbers are showing up with no decimal points. For example, a number that was imporated is shown as 40000 but should be displayed as 400.00

    Is there a quick format to insert the decimal place into the correct area of the number.

    Thank You to anyone who can help with this problem I am having.

    [ This Message was edited by: anctech on 2002-02-18 12:52 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put 100 in an empty cell, copy it, select the cells you want to change, go to Edit, Paste Special, select Values and Divide and click Ok. Now you can format as Number with 2 decimals.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank You very much Juan Pablo G. That soluction worked great.

    Your help with this is very much appreciated.


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