Recent content by PatsyG

Hi Hui Brilliant it works! I was trying something similiar but it's the ? which has me baffled. Do you know what this does? I like to translate the formulas to laymans terms as I will more likely remember them this way! Fantastic!

Hi Narayank991, It seems I can only get one or the other! There must be a way around this, I will keep perservering! Thanks

Hi Narayank991, This is intentional, for example data coming in is -11382, I need it to be -11. However for another data it is -362 but with my formats it's coming in as () and I want it to be blank

Thanks for suggestion Hui but not working, still getting (). The data set is for example -362. Been trying a few other formats adding [<1000000] but no joy.

Hi, I have data which is coming in thousands and need to format to million so using #,###, as the formats. For data which is negative I am getting -11 but need brackets like (11) so using #,###,;(#,###,). However this gives me another problem, data which is negative and the return should be...