+ Reply to Thread
Results 1 to 5 of 5

format cells which show 1 as 0.01 or .01

  1. 11-14-2011, 07:29 PM #1
    fassi is offline
    Registered User
    Join Date
    11-07-2011
    Location
    Pakistan
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    33

    format cells which show 1 as 0.01 or .01

    hi guys,
    I want to format the cell that if I enter 1 in A1, is should display as 0.01
    A1=5 ------ as 0.05 or .05
    A2=3 ....... as 0.03 or .03
    Last edited by fassi; 11-22-2011 at 05:47 AM.
    **fassi**
    Reply With QuoteRegister To Reply
  2. 11-14-2011, 07:49 PM #2
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: format cells which show 1 as 0.01 or .01

    Hello Fassi
    1. Open Excel.
    2. Go to Tools -> Options
    3. Select the Edit tab.
    4. CHECK Fixed Decimal Places: enter 2 on decimal places
    5. Click OK
    HTH
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  3. 11-14-2011, 07:55 PM #3
    fassi is offline
    Registered User
    Join Date
    11-07-2011
    Location
    Pakistan
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    33

    Re: format cells which show 1 as 0.01 or .01

    Quote Originally Posted by vlady View Post
    Hello Fassi
    1. Open Excel.
    2. Go to Tools -> Options
    3. Select the Edit tab.
    4. CHECK Fixed Decimal Places: enter 2 on decimal places
    5. Click OK
    HTH
    thanks
    but I need formatting option only for some cells of this sheet not for all excel.
    Reply With QuoteRegister To Reply
  4. 11-14-2011, 08:00 PM #4
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: format cells which show 1 as 0.01 or .01

    It is in custom formatting

    try

    #\.0##

    turn "off" again the fixed decimal places.
    Reply With QuoteRegister To Reply
  5. 11-15-2011, 07:07 AM #5
    fassi is offline
    Registered User
    Join Date
    11-07-2011
    Location
    Pakistan
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    33

    Re: format cells which show 1 as 0.01 or .01

    thanks vlady
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1