Results 1 to 9 of 9

Thread: Format four digit number to put decimal after first two digits

  1. #1
    Junior Member
    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0

    Question Format four digit number to put decimal after first two digits

    Is there a way to format a four digit number to put a decimal after the first two digits?

    For example, 3568 would become 35.68.

    All numbers are currently in the General format.

    Thanks!

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Why don't you just divide it by 100 in the adjacent cell?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0
    That did work. I was just wondering if I could come up with a custom number format.

  4. #4
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    try percentage

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Try custom number format 00\.00
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  6. #6
    Junior Member
    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0
    That custom formatting worked! Thanks!!

  7. #7
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    659
    Rep Power
    13
    Quote Originally Posted by keithconnolly View Post
    That custom formatting worked! Thanks!!
    You need to keep in mind, though, that the value for that cell is NOT what you see in the cell... your value does not physically change, only its display. So if you type 1234 in the cell, you see 12.34 BUT if you calculate with that value, your calculation will use the full value 1234.

  8. #8
    Junior Member
    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0
    Thanks Rick. One of our databases does not use a decimal to report cents, so I was trying to find a way to clean up the presentation a little.

  9. #9
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    In that case I'd use VBA:

    Code:
    [A1:A20]=[A1:A20/100]

Similar Threads

  1. Replies: 2
    Last Post: 09-06-2014, 09:38 AM
  2. Replies: 4
    Last Post: 08-17-2013, 02:34 AM
  3. Convert a (Possibly) Very Large Positive Decimal Number to Any Base (Up To 36)
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 04-22-2013, 04:52 PM
  4. Replies: 7
    Last Post: 04-21-2013, 07:50 PM
  5. Replies: 3
    Last Post: 03-31-2013, 06:18 AM

Tags for this Thread

Posting Permissions

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