Forum Discussion
Format to return a blank cell
Hi, Thanks for reading this post. I have an Excel spreadsheet which contains a formula which draws its data from another spreadsheet. =Income!O7 I'd like to format that cell so that i...
Thank you for your response, unfortunately neither option provided me with exactly the right result however, it did encourage me to try lots more formatting options and I eventually came up with a custom format which seemed to produce the required format (although I'm not sure how I got to it).
_-* #,##0.00_-;[Red]-* #,##0.00_-;"";_-@_-
Regards,
Garry
