Help with VBA Formula

[JOHN SMITH]

Hi,

I need to convert tex to a number

Example:

10 to 1
01 to 1
20 to 2
02 to 2

and so on

Thank you all,

ciao

 

[George Nicholson]

=SUBSTITUTE(A1,"0","")

 

[Lynn Trapp]

I'm afraid that Substitute is an Excel function, not an Access function.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[George Nicholson]

Yes, well, ahem, I guess that's what happens when you don't pay enough
attention to what newsgroup you're replying to. -)
(But maybe the OP was in the wrong newsgroup too)

A VB equivalent, which will work in Access:
=REPLACE(MyString,"0","")

You may or may not want to play it safe and make sure it's coerced into a
number:
=CLng(REPLACE(MyString,"0",""))