+ Reply to Thread
Results 1 to 3 of 3

Cell formatting problem

  1. #1
    Registered User
    Join Date
    09-12-2021
    Location
    banten
    MS-Off Ver
    2019
    Posts
    1

    Cell formatting problem

    help, when I enter 0.5, it changes to 00.05, even if I enter 0.05 the result is still 00.05.

    I'm using 2019 version
    Last edited by FDibbins; 09-13-2021 at 12:51 AM. Reason: edited thread title

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Help

    Hi, welcome to the forum

    Pretty much everybody comes here for help, and we require that your thread title state what your problem is...HELP hardly does that, now does it?

    I will change it for you -this time - but in future, please give more thought to your thread title.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Cell formatting problem

    what are the cells formatted as? or format the cells as number, does this make any difference? An attachment of the spreadsheet as per the yellow banner would make it easier for you to get a proper answer

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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