Posted to microsoft.public.excel.programming

Pierre M

external usenet poster

Posts: 3

symbols in VBA

I have a macro in which I have a formula which subsitutes symbols for numbers
but VBA turns all the symbols to "?". The formula is as follows:

=IF(I4=1,SUBSTITUTE(I4,1,"ˆš",1),IF(I4=2,SUBSTITU TE(I4,2,"?",1),IF(I4=3,SUBSTITUTE(I4,3,"—",1),IF (I4=0,SUBSTITUTE(I4,0,"—‹",1)))))

How can I gat VBA to use the ˆš — and —‹ symbols in the formula?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Symbols on the keyboard are not the symbols on the screen....	Lisha	Excel Discussion (Misc queries)	2	May 22nd 10 07:29 AM
Symbols	Crissy	Excel Worksheet Functions	8	April 15th 09 05:13 AM
Symbols	Crissy	Excel Discussion (Misc queries)	4	April 14th 09 05:38 AM
symbols	hugoalegria	Excel Discussion (Misc queries)	6	May 12th 08 10:39 PM
add symbols to DMS	surveyor	Excel Programming	1	March 2nd 05 09:49 PM

All times are GMT +1. The time now is 12:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us