Cell auto filled with dots [Solved/Closed]

Question

Ask a question Report

Cell auto filled with dots [Solved/Closed]

jutulu 34 Posts Monday March 10, 2014Registration date September 21, 2015 Last seen - Jun 16, 2014 at 04:49 PM - Latest reply: jutulu 34 Posts Monday March 10, 2014Registration date September 21, 2015 Last seen

- Jun 19, 2014 at 07:27 PM

Excel Ask a question Report

Hello,
I sow it once but not sure where and can't work out how to do it.
Basically, if I write things in excel, I need it to be auto filled with dots so that no space is left in the cell. I hope it is clear, but please let me know otherwise. I know it can be done because I've seen it before but didn't take a note at the time regretfully. Much appreciated

4 replies

Report Respond to jutulu

jutulu 34 Posts Monday March 10, 2014Registration date September 21, 2015 Last seen - Jun 18, 2014 at 06:10 PM

0

Thank you

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.

Report

TrowaD 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen - 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

Report Respond to jutulu

jutulu 34 Posts Monday March 10, 2014Registration date September 21, 2015 Last seen - Jun 19, 2014 at 07:27 PM

0

Thank you

Great! It was just that. Thank a lot. Only, you mean to go to custom option at the bottom, not number

Ask a question

Accepted Answer

5

Thank you

Hi Jutulu,

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

Thank you, TrowaD 5

Something to say? Add comment

CCM has helped 1882 users this month

Cell auto filled with dots [Solved/Closed]

Your reply