Thread: format changes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jocke
 
Posts: n/a
Default format changes


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