Hi
I think this is a longshot but excel is a powerful tool so its worth a try.
Would it be possible to set a the format of one cell (A1) depending on whats in A3.
So if A3 equals "A" then then format would be "0.00"
if A3 equals "B" then the format would be "###/###" (fraction)
Thanks
I think this is a longshot but excel is a powerful tool so its worth a try.
Would it be possible to set a the format of one cell (A1) depending on whats in A3.
So if A3 equals "A" then then format would be "0.00"
if A3 equals "B" then the format would be "###/###" (fraction)
Thanks