-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
comma=false
-
T
Right align dates
The problem I have is exactly as described in this article: https://www.excelforum.com/excel-general/702292-alignment-of-dates.html What seems to be a date is actually text, so correct it, the suggestion was to use the Text To Columns function. It worked manually, so I recorded my steps...- tiredofit
- Thread
- code comma=false other=false space=false text
- Replies: 2
- Forum: Excel Questions
-
D
With ActiveSheet.AutoFilter.Range delete question
I have filtered only the "lasts month" cell in Col 10. How do I get about delete everything that isn't visible, keeping data that is on the screen Sub test() Columns("J:J").Select Selection.TextToColumns Destination:=Range("J1"), DataType:=xlDelimited, _...- drozek
- Thread
- columnsjj.select comma=false delete destination=rangej1 selection.texttocolumns
- Replies: 2
- Forum: Excel Questions
-
N
Text to column with Loop
Hi, I have recorded a macro to convert text to number, is there any simple way to change this code with loop. Sub Convert_To_Numbers() Sheets("RDD Report").Select Columns("B:B").Select Selection.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, _...- nianchi111
- Thread
- comma=false other=false semicolon=false space=false tab=true
- Replies: 1
- Forum: Excel Questions
