Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() hi guys. can anyone tell me why my cell changes when i edit an excisting formula. Like this. original formula: =F1*F3*1,66 shows in spreadsheet the correct value like "18" when i edit the formula then the spreadsheet shows "=F1*F3*1,667" in text if i delete the cell and type in the formula again, it's ok if i edit the formula once again then the same thing happens again (cell value shows like text) regards Jocke -- jocke ------------------------------------------------------------------------ jocke's Profile: http://www.excelforum.com/member.php...nfo&userid=766 View this thread: http://www.excelforum.com/showthread...hreadid=534876 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |