Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell format changes when formula copied?
I am having trouble putting formulas into a cell. I copy a formula into a
cell and then the cell I copied it froms formatting changes the moment I press return to leave the cell. It shows the formula not the result. This happens in both the cell I copied from and paste into. The only way I know to set things correct os to undo. What is happenning? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell format changes when formula copied?
Sounds like the cells you're pasting into are formatted as Text. XL
doesn't parse Text entries. Format the target cells as General. In article , Todd wrote: I am having trouble putting formulas into a cell. I copy a formula into a cell and then the cell I copied it froms formatting changes the moment I press return to leave the cell. It shows the formula not the result. This happens in both the cell I copied from and paste into. The only way I know to set things correct os to undo. What is happenning? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
How do I use cond format formula to set cell text and color? | Excel Discussion (Misc queries) | |||
copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |