How do I stop a general format from being autoformatted to ...

[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 but it changes the numbers of the other cell automatically.

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, 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' but didn't help.

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

Cheers,
Gaufres

 

[shades]

Howdy. One other possibility. Go to Tools > AutoCorrect > Autoformat as you type. And uncheck the box "include new rows and columns in list".
________
Hot Box Vaporizers

 

[Rod D]

Of course they will change!

When I type a number into these cells, for example, B29, all numbers in the cell, B24-26 will get changed!

This has nothing to do with formatting!

The calculation in row 24 (kg DM/ha/day Supply) adds up the values in rows 27, 28, 29 and 30.

=Sum(B27..B30)

Row 25 is dependant on row 24

=B24*B13

and row 26 is dependant on row 25

=B23-B25

...by adding or changing a value in row 29 will make all the values in that column in rows 24 to 26 change as the formulae are re-calculated.

If this is not what you wanted or expected, then the calculations in your spreadsheet need looking at....

Hope this helps
Regards
Rod