Formula loses format

Not that I know of.

I have copied the first few lines and attached the worksheet.

You will see what happens if you type a number under the £10.

Weird!

Noel


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:urpe3i5LFHA.732@TK2MSFTNGP12.phx.gbl...
> Noel,
>
> Not surprisingly, I don't get that effect.
>
> Do you have any worksheet event code that might be doing it?
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message
> news:uLEwea5LFHA.1268@TK2MSFTNGP14.phx.gbl...
>> On an accounts spreadsheet I use, I have the total for the line near the
>> beginning of the row in the 'C' column (not at the end due to the auditor
>> asking for it to be next to the clients' names - it enables easier
> checking
>> for him). The total column is enclosed in double thick black lines to
>> make
>> it stand out, whilst the other columns are formatted in thin black lines.
>>
>> The problem is that when I enter an amount along a row and hit <return>
> the
>> thick double line either side of the total in column C changes so that
>> the
>> left side of the cell becomes a single thickness (the right side remains
>> unaltered).
>>
>> At the moment I have to use the format painter each time to overcome the
>> problem but I guess there must be a way so stop it happening?
>>
>> Any ideas?
>>
>> Thanks,
>>
>> Noel
>>
>>
>
>

Still doesn't happen here. There is another factor.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message
news:u6YXXq5LFHA.3336@TK2MSFTNGP10.phx.gbl...
> Not that I know of.
>
> I have copied the first few lines and attached the worksheet.
>
> You will see what happens if you type a number under the £10.
>
> Weird!
>
> Noel
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:urpe3i5LFHA.732@TK2MSFTNGP12.phx.gbl...
> > Noel,
> >
> > Not surprisingly, I don't get that effect.
> >
> > Do you have any worksheet event code that might be doing it?
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Noel S Pamfree" <Noel.spamfree@hotmail.com> wrote in message
> > news:uLEwea5LFHA.1268@TK2MSFTNGP14.phx.gbl...
> >> On an accounts spreadsheet I use, I have the total for the line near
the
> >> beginning of the row in the 'C' column (not at the end due to the
auditor
> >> asking for it to be next to the clients' names - it enables easier
> > checking
> >> for him). The total column is enclosed in double thick black lines to
> >> make
> >> it stand out, whilst the other columns are formatted in thin black
lines.
> >>
> >> The problem is that when I enter an amount along a row and hit <return>
> > the
> >> thick double line either side of the total in column C changes so that
> >> the
> >> left side of the cell becomes a single thickness (the right side
remains
> >> unaltered).
> >>
> >> At the moment I have to use the format painter each time to overcome
the
> >> problem but I guess there must be a way so stop it happening?
> >>
> >> Any ideas?
> >>
> >> Thanks,
> >>
> >> Noel
> >>
> >>
> >
> >
>
>
>