Results 1 to 4 of 4

How do I Scale a Number using Format Cells Custom?

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question How do I Scale a Number using Format Cells Custom?

    I have a number in a cell of 1025132.36

    I need to scale it down to this number with this formatting: 1,025.13
    (Two decimal places with comma separaters)

    Basically it is dividing it by 1000 or scaling it by 3 (move the decimal place to the left three places).

    I cannot use /1000 in the cell and I cannot reference it to/from another cell. I must use something under Format/Cell. I was trying to create a custom format.

    I saw in another forum thread to use #”.”###. This does the scaling but then I can’t make the number viewed with only two decimal places. Also when I tried to add comma separators for thousands it put a comma right before the decimal.

    Any help you could provide would be appreciated.

    Thanks!
    Last edited by gwolf; 08-06-2009 at 08:34 AM.

Thread Information

Users Browsing this Thread

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

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