You can change the Formating before or after entering the formulae. Diana > > That would appear to be my error - not formatting the new > column first. > > Thanks for your help. > > Anne > > >