Aug 2, 2006 #1 vladk Programmer May 1, 2001 991 US Hi, Who knows what property of what object houses the text of the formula bar in EXCEL? For example, I type '66. And I want to distingish it from 66. It appears that neither Text, nor Formula properties do not help.... Thanks! vladk
Hi, Who knows what property of what object houses the text of the formula bar in EXCEL? For example, I type '66. And I want to distingish it from 66. It appears that neither Text, nor Formula properties do not help.... Thanks! vladk
Aug 2, 2006 1 #2 PHV MIS Nov 8, 2002 53,708 FR Have a look at the PrefixCharacter property. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886 Upvote 0 Downvote
Have a look at the PrefixCharacter property. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886