How to stop a general format cell

[Gaufres]

Hi there

Does any one knows how to stop formatting cells automatically? I didn't tell Excel to format cells into any category types or formulae but it changes the numbers of the OTHER cells automatically whenever I type in a number.

Please find an attachment. In the cell B29, C29, D29, E29, and F29, they don't have any formulae and their cell format is set to "General". When I type a number into these cells, for example, the cell B29, all numbers in the cell, B24-26 will get changed!

I have unticked an option, Tools > Options > Edit tab > 'Extend data range formats and formulas', checked ‘Data’ > ‘Validation’ to see if there are any hidden rules, and viewed code from the sheet tab (there was nothing!) but none of them help.

It would be a great help if anyone advise me anything!

Cheers,
Gaufres

[Ardus Petus]

Works by me:

I entered some number in B29, and B24:B26 kept their original format (values
changed of course beacause of formulae).

HTH
--
AP

"Gaufres" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> Hi there
>
> Does any one knows how to stop formatting cells automatically? I
> didn't tell Excel to format cells into any category types or formulae
> but it changes the numbers of the OTHER cells automatically whenever I
> type in a number.
>
> Please find an attachment. In the cell B29, C29, D29, E29, and F29,
> they don't have any formulae and their cell format is set to "General".
> When I type a number into these cells, for example, the cell B29, all
> numbers in the cell, B24-26 will get changed!
>
> I have unticked an option, Tools > Options > Edit tab > 'Extend data
> range formats and formulas', checked 'Data' > 'Validation' to see if
> there are any hidden rules, and viewed code from the sheet tab (there
> was nothing!) but none of them help.
>
> It would be a great help if anyone advise me anything!
>
> Cheers,
> Gaufres
>
>
> +-------------------------------------------------------------------+
> |Filename: stop changing please.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4670 |
> +-------------------------------------------------------------------+
>
> --
> Gaufres
> ------------------------------------------------------------------------
> Gaufres's Profile:
http://www.excelforum.com/member.php...o&userid=23339
> View this thread: http://www.excelforum.com/showthread...hreadid=534867
>