format changes

J

jocke

hi guys.
can anyone tell me why my cell changes when i edit an excistin
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" i
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 agai
(cell value shows like text)

regards Jock
 
B

Bryan Hessey

I presume that you are using the comma as the decimal point.

Sometimes a formula copied into a cell shows as a formula but does no
calculate, I notice this quite often when copying formula from thi
forum.

Editing the cell will activate the formula, but in your case the ite
uses a comma for the decimal point, if you do not then you could have
problem, as the 'formula' may then be considered 'text'

HTH

--
 
Top