Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula cell format change
I have a new "feature" that showed up this week. If I type a formula
referencing cells that have a specific format the format of the formula cell changes to match. for example column A has been formated as text. if I type the formaula =A2 & A3 into B2 (still with the default General format) when I press enter the format changes to text for B2. the result is correct untill I edit B2 at which time the result changes to be "=A2 & A3". this only occurs if all of the source cells have the same format and you are only referencing cells. =A2 & " " & A3 does not change the format of the formula cell. |
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 you change a format WITHIN a formula? | Excel Worksheet Functions | |||
Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
cant change the cell format it shows too many different cell form | Excel Worksheet Functions | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) |