Last seen: May 22, 2025
You should be able to use #,##0.00(E) or #,##0.00("E")
Really? It was the first hit for me using those search terms:
Have you checked any conditional formatting formulas, data validation, charts, table formulas etc? Bill Manville’s FindLink add-in is very useful for ...
If your XLOOKUP is finding a match but the cell in the result column is blank, it will return 0. If you can't see the 0, then either the cell format o...
Yes, but a screenshot doesn't really help if the display is suppressed. 😉 If you alter the XLOOKUP to remove the 'if not found' argument do all the r...
Can you show us the Edit links dialog?
PQ should not return 0 for a cell that contains "" (which is not the same as null, by the way). Are you sure the source sheet doesn't simply have the ...
I suspect the issue is in your transform file function.
Without seeing the query we can only guess, so most likely cause I think would be that the column name is not exactly the same as specified in the que...
It is polite to mention cross-posting:
Click on the button with the two down arrows on it at the top of the Content column (to the left of the one you currently have selected in that pictur...
You're most welcome. 🙂
You didn't use the code I posted, which was correct as it was. 😉 I have copied it into your workbook, attached.
Try turning the first sub into a function that only returns True if all fields are complete: Sub Button1_Click() If FieldsAreComplete Then Cal...
Where did the data in column D come from? That's where the problem actually originates, since as Mynda said, although the values look like whole numbe...