How to determine cell format in different locals

[Guest]

If I use the following syntax on any locale can I expect to get
"S#" back for cell formated as scientific ?
Works in US english just wondering if it would internationally ?
can I use myFormat=cell("format",ThisCell).

If not is there a function that can change the value coming back to compare to
a speicfied LCID ?

Something like IF(
LCID(USENGLISH,MID(cell("format",ThisCell),1,1))="S",1,0)

 

[Frank Kabel]

Hi
works also in other langiuage version (or your formula does at least
for the German version).