Hello, When I try formatting cells to change to negative numbers (i.e. use accounting format or currency format), it will not change negative numbers to show in brackets. What do I do?
Right now I have a range of numbers M4:N13 Than I have another range of numbers B4:K11 I would like the numbers in range B4:K11 to format with a red border if they match the numbers in range M4:N13.
If I add a column of hh:mm to get a total, how do I get total dd:hh:mm if the total exceeds 24 hours?
I have to spilt a cell containing a number which starts with zero though I only need the last half of the number. The format of the cell is currently text to keep the zero though I need it to be a
(e.g. 1,000,000,000 should be 1 000 000 000) I've tried # ##0 but it doesn't work. I need it to work no matter how large the number is.