I'm working on a macro created by someone else and I have got stuck. The below VBA code is dropping the first 0 when the number is 01350. i have tried formatting the actual sheet which doesnt work as it needs to be uploaded into out finance system.
wsLgr.Cells(wsLgr.UsedRange.SpecialCells(xlCellTypeLastCell).Row, "H").FormulaR1C1 = wsParam.Range("C4").Text '* Cost Centre
I am using the function =CONCATENATE(A2,B2,C2)
Why is it dropping the 0 from B2?
Table 1 Table 2 Table 3
C 012 A
C12A
I have a spreadsheet sent from another company. The cell has the date first and then the time. My formula figures the time only so I need to drop the date. I tried to change the cell but it won't change. Any suggestions. The spreadsheet used to have the time only and I would convert it to am/pm. My formula doesn't work with the new setup.
View 9 Replies View RelatedWhen I save my file as a csv, it drops leading zeros in my zip codes. Formatting the column as text or even zip code only helps when I save it as xls - as soon as I switch it to csv it drops them.
View 9 Replies View RelatedI have a macro that goes out to a database and pulls in updated numbers. However the numbers come in as text because they have leading 0's:
011204
011208
011209
015942
017536
The only way I can get the numbers formatted as a number and drop the leading 0 is to click on the yellow exclamation tab that pops up and click, Convert to Number. Is there any way I can write this into my macro to automatically do for me? I tried selecting the column and reformatting this way but it would not drop the leading zero:
The idea is to have a sheet that where I can swap the content seen by using a drop-down list. see attachment.
Capture.PNG
I need to get a formula to calculate the average of the best 3 scores out of 4, but there is some that do not have a value in a cell (so some are only out of 3 scores not 4) and if i simply drop the lowest value and sum the rest, it will incorrectly calculate the average.
View 9 Replies View Related