ExcelBanter - Format of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Format of cell (https://www.excelbanter.com/excel-discussion-misc-queries/222415-format-cell.html)

Cells A!, B1, C1 and D1 have a "Number" or "General" format:

A1 contains 5
B1 contains 6
C1 contains 2
D1 contains formula =A1+B1 so 11 is displayed.

When I change the formula in D1 to =A1+C1 and press "Enter", the
format of D1 changes to "Text" so "=A1+C1" is displayed.

How can I keep the cell's original format?

..

Hi,

It sounds like there is a little autoformatting going on. It suggests that
cell C1 may be formatted to text. However, to make sure I would select all
the cells A1:D1 and format them to Number.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"GARY" wrote:

Cells A!, B1, C1 and D1 have a "Number" or "General" format:

A1 contains 5
B1 contains 6
C1 contains 2
D1 contains formula =A1+B1 so 11 is displayed.

When I change the formula in D1 to =A1+C1 and press "Enter", the
format of D1 changes to "Text" so "=A1+C1" is displayed.

How can I keep the cell's original format?

..