excel format cells

  1. M

    Help with Excel number format - cell formatting

    Looking for excel cell formatting as below. Decimal should be displayed only if present in source data. negative values to be displayed in number. Amount to be in million comma format/style. Requesting members to help with cell formatting to derive below result. Input data in cell Output...
  2. E

    Format cells issue

    Hello Guys, I m having one column with format cells: [h]:mm (exemple 48:00 which means 48h) The same column value i divided it by 8 (number of worked hours per day)--> 48:00/8h and it gave 6:00 I want that the result be 6 (6 days) instead of 6:00 . I tried other format cells but not getting...
  3. A

    Custom format cell to consider dash as zero in excel

    I import data from web external query in excel in which zero value represented as dash, to further calculation on this I need to consider this dash as zero for that I have macro to convert dash to zero but, data gets refreshed every 5 min. so I need to run that replacement macro every 5 min...
    • adpatel
    • Thread
    • excel excel & formula excel & match & replace excel format excel format cells
    • Replies: 3
    • Forum: Excel Questions
  4. S

    Name Reverse and setting Proper format (Excel)

    Hi, Can I please ask for help, this is the formula im using =PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4))) the result of the formula is at Name Row =PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4))) I wanted to make the name look like Abbas, Shin...
  5. R

    Cell Format Include a Footnote

    Hi team, I was wondering if there was a way to format a cell in excel so that it has a footnote. The objective is to mantain the value of the cell dynamic (i'ts being picked up with a formula). Any ideas? For example it would be A1 5 A2 3 A3 =A1+A2 Display 81 Thank you Daniel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top