Forum Discussion

Jeff_JPK's avatar
Jeff_JPK
Copper Contributor
Jul 12, 2023
Solved

Macro to edit the current cell

I export a report from our ERP system to Excel. Our job numbers use letters to represent iterations of the job of the format 12345E-01. When this is exported to Excel, it is displayed as 1.23E+03, an...
excel
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Jul 12, 2023

    Jeff_JPK 

    Sub E_Jobs()
    ActiveCell.Value = "'" & Replace(ActiveCell.Value, ".", "") & "E-01"
    ActiveCell.Offset(1).Select
End Sub
HansVogelaar's avatar
HansVogelaar
MVP
Jul 12, 2023

Jeff_JPK 

Sub E_Jobs()
    ActiveCell.Value = "'" & Replace(ActiveCell.Value, ".", "") & "E-01"
    ActiveCell.Offset(1).Select
End Sub
  • Jeff_JPK's avatar
    Jeff_JPK
    Copper Contributor
    Jul 12, 2023
    Thank you Hans! Works like a charm!

Resources