convert to number macro

[niukvba]

Hi guys,
I am working with a report that has a column of number in a text format.
If you are working with it manually, you can click on the exclamation mark and then convert it to number.
I tried to record a macro with this action, but the macro just records the selecting of the cell.

What is the code to convert the whole column to regular numbers?
By the way, selecting a cell and changing the format to number through the ribbon does not help, it still requires to click the convert to number.

Thanks!

[Crooza]

Have you tried to just type in cell b1
=value(A1)

This will change the text to values. You can then copy and paste as values once you've converted to values

[marreco]

try too

Please Login or Register  to view this content.

[HaHoBe]

Hi, niukvba,

code may look like this:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Ciao,
Holger

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[niukvba]

Thank you all!
This is solved. The moderator explained me once how to mark a thread a s solved, but I can't find this option..

[HaHoBe]

Hi, niukvba,

itīs on the very start of the FAQ:

Mark Your Thread Solved
To mark your thread solved do the following:
New Method
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Old Method
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Ciao,
Holger