To whom it may concern,
I have this issue with one of my VBA files and I just can't figure it
out. I have this search and replace macro that does a good job but I
can't figure out why it places a negative (-) sign on values without
a space after the parentheses. Your help is greatly appreciated.
Start example
https://docs.google.com/spreadsheets...it?usp=sharing
Finished example
https://docs.google.com/spreadsheets...it?usp=sharing
Sub Discus_Fix()
'
' Discus_Fix Macro
' Replaces redundant information on Discus AS9102 Report
Cells.Replace What:="note: ", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
_ ReplaceFormat:=False
End Sub
Your data cells contain text, but are not formatted as 'Text'. Thus,
Excel is evaluating (.140) as a number where the parenthesis indicate a
negative value. Thus, your data alignment is changed to numeric and
displays in your default format for a negative value.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion