How to best convert all the numbers to number format?

[Romano_odK]

Good afternoon,

I am trying to convert all the numbers in the sheet to a number format but I can't get it to work. What is the best way to do this?

Thank you for your help?

Romano

Telling 09082023.xlsx
	A	B	C	D	E	F	G	H
2	Artikelcode	Artikelomschrijving	Magazijnlocatie	Voorraad	Getelde waarde	Verschil	Eenheid	Standaard kostprijs
3	100000	Vito Glaserfix 111 6x2 mm wit - 10x25 m	A00	121	0	-121	pak	6.7
4	100000	Vito Glaserfix 111 6x2 mm wit - 10x25 m	P02B	0	121	121	pak	6.7
5	100001	Vito Glaserfix 111 6x2 mm zwart - 10x25 m	A00	120	0	-120	pak	6.7
6	100001	Vito Glaserfix 111 6x2 mm zwart - 10x25 m	P04B	0	122	122	pak	6.7
7	100002	Vito Glaserfix 111 6x3 mm wit - 10x25 m	A00	79	0	-79	pak	7.31
8	100002	Vito Glaserfix 111 6x3 mm wit - 10x25 m	P02B	0	79	79	pak	7.31
9	100003	Vito Glaserfix 111 6x3 mm zwart - 10x25 m	A00	88	0	-88	pak	7.31
10	100003	Vito Glaserfix 111 6x3 mm zwart - 10x25 m	P04B	0	88	88	pak	7.31
11	100004	Vito Glaserfix 111 6x4 mm wit - 10x25 m	A00	113	0	-113	pak	9.95
12	100004	Vito Glaserfix 111 6x4 mm wit - 10x25 m	P02C	0	60	60	pak	9.95
13	100004	Vito Glaserfix 111 6x4 mm wit - 10x25 m	P02B	0	17	17	pak	9.95
14	100005	Vito Glaserfix 111 6x4 mm zwart - 10x25 m	A00	70	0	-70	pak	9.95
15	100005	Vito Glaserfix 111 6x4 mm zwart - 10x25 m	P04B	0	69	69	pak	9.95
16	100006	Vito Glaserfix 111 9x2 mm wit - 10x25 m	A00	70	0	-70	pak	7.74
17	100006	Vito Glaserfix 111 9x2 mm wit - 10x25 m	P01B	0	70	70	pak	7.74
18	100007	Vito Glaserfix 111 9x2 mm zwart - 10x25 m	A00	57	0	-57	pak	7.74
19	100007	Vito Glaserfix 111 9x2 mm zwart - 10x25 m	P03B	0	58	58	pak	7.74
20	100008	Vito Glaserfix 111 9x3 mm wit - 10x25 m	A00	232	0	-232	pak	8.59
21	100008	Vito Glaserfix 111 9x3 mm wit - 10x25 m	Q06B	0	90	90	pak	8.59
22	100008	Vito Glaserfix 111 9x3 mm wit - 10x25 m	Q07A	0	32	32	pak	8.59
23	100008	Vito Glaserfix 111 9x3 mm wit - 10x25 m	Q08B	0	110	110	pak	8.59
24	100009	Vito Glaserfix 111 9x3 mm zwart - 10x25 m	A00	388	0	-388	pak	8.59
25	100009	Vito Glaserfix 111 9x3 mm zwart - 10x25 m	Q05B	0	110	110	pak	8.59
26	100009	Vito Glaserfix 111 9x3 mm zwart - 10x25 m	Q06B	0	270	270	pak	8.59
27	100009	Vito Glaserfix 111 9x3 mm zwart - 10x25 m	Q07A	0	98	98	pak	8.59
Tellingen

 

[Bosquedeguate]

Your sample sheet looks Good. What numbers are your trying to covert where you are having problems. Please provide examples.
Also, provide the formulas or code that you have used that does not work.

 

[Lastejp]

You can do sometthing like this, for example

ThisWorkbook.Sheets("Telligen").Range("D:D").NumberFormat = "0,00#.0"