How to determine cell format in different locals
From: goLeafs (goLeafs_at_discussions.microsoft.com)
Date: 07/23/04
- Next message: Frank Kabel: "Re: Excel MVP"
- Previous message: Frank Kabel: "Re: "Something" is overriding my Format!"
- Next in thread: Frank Kabel: "Re: How to determine cell format in different locals"
- Reply: Frank Kabel: "Re: How to determine cell format in different locals"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Jul 2004 13:30:02 -0700
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)
- Next message: Frank Kabel: "Re: Excel MVP"
- Previous message: Frank Kabel: "Re: "Something" is overriding my Format!"
- Next in thread: Frank Kabel: "Re: How to determine cell format in different locals"
- Reply: Frank Kabel: "Re: How to determine cell format in different locals"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
