Dear sir/madam,
I facing the problem to use the formula after convert from Microsoft office to open office, can you help to change the formula as per below: Original from Execel:- =IF(G3=””,””,TEXT(G3,””)) After convert to Open office, =IF(G3=””;””;TEXT(G3;””)) But , the result show err:504 May I know how to settle this formula. Please advice Thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.4/898 - Release Date: 12-Jul-07 4:08 PM