cell format round and display 2 decimal places

Question

I have one cell formatted as Number and  with 2 decimal places   The actual number is 69 30217 so in my cell  imagine cell A1  it appears like 69 30  This is OK   With that cell  I m making some concatenations so if I do something like this     amp E5 amp     The number appears as 69 30217  But if I do this     amp ROUND E5 2  amp     The number appears as 69 3   What can I do to display that zero  What to show 69 30

User · Answer

Input  0 0 1 1000   FIXED E5 2   Output  0 00 0 10 1 000 00   TEXT E5  0 00    Output  0 00 0 10 1000 00  Note  As you can see FIXED add a coma after a thousand  where TEXT does not

User · Answer

Use this   amp TEXT E5  0 00   amp

User · Answer

Another way is to use FIXED function  you can specify the number of decimal places but it defaults to 2 if the places aren t specified  i e    FIXED E5 2   or just   FIXED E5

User · Answer

I use format  Number  2 decimal places  amp  tick   use 1000 separater    then go to  File    Options    Advanced   scroll down to  When calculating this workbook  and tick  set precision as displayed   You get an error message about losing accuracy  that s good as it means it is rounding to 2 decimal places  So much better than bothering with adding a needless ROUND function

[excel] cell format round and display 2 decimal places

Examples related to excel

Examples related to rounding