To save me opening a new thread:
I have an Excel worksheet for personal banking. The copy of Excel I use has been going for ten years. For some reason it will not now go past £9999.99. When I calculate to a sum more than that it comes up with #####. It used to calculate with five figures so why not now?