whenever i enter an array formula the active cell immediately defaults to a % format with 15+ decimal places. i'm not sure who thought that would make sense, or why an active cell would ever change formats without being directed to, but i find it very annoying, and am tired of reformatting, and then resizing, the cells. does anyone know a way to deactivate this feature?
many thanks.
many thanks.