+ Reply to Thread
Results 1 to 5 of 5

Add zeros after formula calculations

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    cyprus
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation Add zeros after formula calculations

    Hello, i need help for a project that i have.
    I have A1 that contain numbers, B1 that contain number, and i want to multiply those 2 and at the end of result i want to add zeros on front. Let me give you an example:

    A1 field has data :00.375 B2 has data: 6.49 C1 has the multiply result of A1+B1: 2.43 (But i want when the calculation is done and have the result 2.4 to add 2 zeros on front and become: 002.43 or if the result is for example: 65.20 to add 1 zero on front and become 065.20 , and if the result is 102.20 do not add anything on front.

    So in total i need to have the 5 digits of number.

    Can someone help please?

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Add zeros after formula calculations

    Welcome to the forum..

    * select C1.
    * Go to Format Cell (Ctrl + 1)
    * Select Number Tab > Category > Custom
    * In Type section write "000.00"

    will display result always as prefix 0, with max 3..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Add zeros after formula calculations

    Hi,

    Simply custom format the desired cells to type: 000.00

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    09-11-2012
    Location
    Belfast
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Add zeros after formula calculations

    Hi Marios_dem

    You could use a custom format of '000.00' in the column you are storing your results in. This would give the following result:

    0.375 x 6.49 = 002.43
    23 x 4.3 = 098.90
    75 x 6.3 = 472.50

    Does this help?

    Regards
    Stephen.

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Add zeros after formula calculations

    depends why you want it like that custom format as suggested or =TEXT(A1*B1,"000.00")
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 04-09-2012, 02:28 PM
  2. Replies: 2
    Last Post: 02-22-2008, 11:18 AM
  3. make the #N/A from Lookups act like Zeros in sum calculations
    By JB1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2007, 08:27 PM
  4. [SOLVED] How can I replace zeros with blank spaces during calculations plea
    By Ted in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-02-2006, 11:10 PM
  5. Replies: 1
    Last Post: 05-04-2005, 02:06 PM

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