VBA Macro Assistance

[bepedicino]

I have a spreadsheet where many of the cells contain a scientific notification, I need them to be text cells. I tried changing the format but Excel will not convert the cells unless I double left-click in each cell and then press enter in each of the affected cells.

Could someone please assist by providing me a macro that will double left-click on each cell and then move on to the next cell for all cells in column B of the current active sheet? Or if there is another better solution that would be great. Your assistance is greatly appreciated.

 

[Momentman]

Have you tried doing a text to columns>fixed width> choosing text format.....

 

[bepedicino]

Yes, I have. Unfortunately it did not correct the issue.

 

[Momentman]

Yes, I have. Unfortunately it did not correct the issue.

I am surprised that doesn't work for you.

In any case, maybe a macro like this (untested)

Sub DoubleClickCells()
    Dim rng As Range
    For Each rng In Selection
        Application.SendKeys "{F2}{ENTER}"
    Next
End Sub

Create a shortcut to run the macro and press shortcut to trigger it. If run from the visual basic editor, you won't get the desired results

Highlight the cells you want to double click and then press shortcut to run macro

 

[bepedicino]

Your solution did the job, thank you!

 

[Momentman]

Your solution did the job, thank you!

You are welcome. Thanks for the feedback