| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format of cell
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? .. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format of cell
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? .. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Hybrid Mode
