excel format

Hey everyone, I have recently converted from a PDF to Excel and have various formatting issues which I am trying to fix. Below is an example of the table once converted. ABCDEFGHIJKLMNOP1Ref 1Ref 2TitleDocsTimeStatusRemarksLastNext 1Next 2Next 32testremark 13123456test aN/Aremark 24remark...

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...

Hi, we know that the excel sheet standard number start with #1, if you want to change to start by another number such as 5 put +4 after &[Page], like this &[Page]+4 of &[Pages] , it will appear like this 5 of 70 , and so

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...

Using Excel 2016, exactly HOW do I copy the information from my worksheet into a proper Excel format in MrExcel.com? I have tried and, while it pastes, it does not have the Excel-type format I see in other posts (like borders and stuff).

I have a couple of protected worksheets in a workbook and when I right-click on the sheet name and unprotect the sheet, columns I have specifically protected in that sheet, go back to being protected after I do one action on the sheet. That one "action" could be, clicking into a cell that has a...

Hi, I have a complicate excel formatting to do but I have no idea where should start first. There are few criteria that need to meet. 1. When cell value in F3 and H3 is filled, the time at cell N4 should auto add 3 hour based on the time on N3. 2. If system time is exceed then the time...

Hi all, I need some help. I have a friend with excel 2003 installed years ago. Last month, his excel behave strangely. I don't know why and how, each time he types a numeric value into a cell (e.g 123456789 or 123456 or 1234) then the format automatically change to 123.456.789, 123.456 and...