Cell auto filled with dots
Solved/Closed
jutulu
jutulu
- Posts
- 34
- Registration date
- Monday March 10, 2014
- Status
- Member
- Last seen
- September 21, 2015
jutulu
- Posts
- 34
- Registration date
- Monday March 10, 2014
- Status
- Member
- Last seen
- September 21, 2015
Related:
- How to fill excel cell with dots
- Auto Fille Cell Based on Different Cell Value ✓ - Forum - Office Software
- Auto filling bill number and date ✓ - Forum - Excel
- Auto run macro when cell value changes ✓ - Forum - Excel
- How to run macro when data entered in a cell - Guide
- Excel auto copy cells to another sheet - Guide
3 replies
TrowaD
Jun 17, 2014 at 11:52 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 17, 2014 at 11:52 AM
Hi Jutulu,
You mean something like this?:
Best regards,
Trowa
You mean something like this?:
Private Sub Worksheet_Change(ByVal Target As Range) Dim MyWidth As Currency MyWidth = Target.ColumnWidth Target.EntireColumn.AutoFit If Target.ColumnWidth >= MyWidth Then Target.ColumnWidth = MyWidth Exit Sub End If Do Target = Target & "." Target.EntireColumn.AutoFit Loop Until Target.ColumnWidth = MyWidth End Sub
Best regards,
Trowa
jutulu
Jun 18, 2014 at 06:10 PM
- Posts
- 34
- Registration date
- Monday March 10, 2014
- Status
- Member
- Last seen
- September 21, 2015
Jun 18, 2014 at 06:10 PM
Hi Trowa,
I didn't want to use macros. However, there is a much easier way to do it. I sow it once and thought it was very cool, but never wrote it down and can't remember it. Thanks anyway. Hope can find the answer to it.
I didn't want to use macros. However, there is a much easier way to do it. I sow it once and thought it was very cool, but never wrote it down and can't remember it. Thanks anyway. Hope can find the answer to it.
TrowaD
Jun 19, 2014 at 10:35 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 19, 2014 at 10:35 AM
OK Jutulu, I got it.
Go to cell properties > number tab > go to the manual input and type in "@*."
Enjoy.
Best regards,
Trowa
Go to cell properties > number tab > go to the manual input and type in "@*."
Enjoy.
Best regards,
Trowa
jutulu
Jun 19, 2014 at 07:27 PM
- Posts
- 34
- Registration date
- Monday March 10, 2014
- Status
- Member
- Last seen
- September 21, 2015
Jun 19, 2014 at 07:27 PM
Great! It was just that. Thank a lot. Only, you mean to go to custom option at the bottom, not number