Inserting 0 in selected cells in excel

[Byrner]

Hello , A very warm Hello or Hi to everybody from Ireland

I have just joined my name is Maureen, Not great on computers but using excel for a small craft business I am trying to get going.
Can anybody help? I need to insert the number 0 in selected cells , is there a quicker way to do this other then by typing in 0 opposite every selected name?
I have a long list of customer names, if one name on the list e has order from me in the past I need to insert 0 in the column beside their name.
Its an old list, so I have to read from the list and and when a name matches insert the 0
Any help would be really great
Thanks again
Maureen

 

[Byrner]

Mick
I love you ..Thank you you just saved me hours of typing , it works great
THANK YOU SO MUCH
Maureen

 

[Byrner]

Thanks to all
Its working now , well done Mick

Thanks
M.

 

[MickG]

You're very welcome

 

[Byrner]

Hi Again ,
Its works great and thanks again just one thing if you know how
it works only in column G is it possible to get it working in 3 columns on the same sheet ,
Reason is I have 3 different categories and it would be very helpful if I could also tick off which item they brought.
If it only works on one column that is fine
Thanks
Kind Regards Maureen

 

[Byrner]

Anyone know how to do this?
My head is just about to fall off my shoulders now , please ban all computers and bring back the carbon paper and pencils
Thanks to all and especially to anyone who can help
M

 

[Fluff]

How about

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   If Intersect(Target, Range("G:I")) Is Nothing Then Exit Sub
   Cancel = True
   Target.Value = IIf(Target.Value = "", 0, "")
End Sub

 

[Byrner]

Thanks Fluff, Really grateful
Funny thing happened my PC crashed as I was working in excel it restarted but now all my files are gone and Microsoft edge is installed without any prompt from me.
So just lost all my work. but will be able to use your calculations in the future , I will always back my files from now on
Regards

 

[Byrner]

Hi Again,
Looking for a little more help , I am trying to list all past costumers from paper files to excel, I got great help from Mick and Fluff on Friday so now I just need to take on to the final step. The code above from Fluff allows me to double click and insert a (0) in columns G to i, what I need to do now it extend this from Coloum G to Coloum U . Theses Columns represent items I sell and by double clicking in a cell within these columns I can quickly select an item.
Hope this makes sense and I am really great full to you all
Thanks
I have pased a n example of what I am doing

Name	Address 1	Address 2	Country	Post Code	Telephone	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	Totals	Totals
abc	x	x	x	x	x																0
																					0
										Each number reperesent items purshased											0
																					0
	Names Addresses Contact info																				0
							WOULD LIKE TO BE ABLE TO DOUBLE CLICK ANYWHERE IN GREY BOX TO INDICATE A SALE														0
																					0
																					0
																					0
																					0
																					0
																					0
																					0

<colgroup><col><col><col span="4"><col span="17"></colgroup><tbody>
</tbody>

 

[Byrner]

Sorry about the spelling mistakes above tried to edit it but could not, Typing is not my great strength as I was born in a age of Inkwells and Ink.
Maureen

 

[MickG]

Try changing the "I" to a "U" in the line below:-

Intersect(Target, Range("G:I"))