Convert Part of Formula as values

[Sufiyan97]

Is there any way to convert B2 formula as =6977835.66/1000 and so on

Book2
	A	B	C
1	Original	Divide By 1000	Expected Result
2	6977835.66	6977.836	6977.83566
3	51131.07	51.13107	51.13107
4	83389.14	83.38914	83.38914
5	2282.02	2.28202
6	1419610.69	1419.611
7	127156.62	127.1566
8	340270.89	340.2709
9	51378.26	51.37826
10	73270.59	73.27059
11	118027.98	118.028
12	33044.55	33.04455
13	3165.57	3.16557
14	1841.46	1.84146
15	19157.09	19.15709
16	11558.97	11.55897
17	11536.66	11.53666
18	45436.29	45.43629
19	1023.51	1.02351
20	1627.41	1.62741
21	2024.66	2.02466
22	21298.27	21.29827
23	16710.56	16.71056
24	9732.90	9.7329
25	13451.94	13.45194
26	2175.02	2.17502
27	922.08	0.92208
28	100490.52	100.4905
29	0.00	0
30	14149.05	14.14905
31	91.92	0.09192
32	118679.59	118.6796
33	290.00	0.29
34	38441.99	38.44199
35	8147.30	8.1473
36	11852.70	11.8527
37	572.54	0.57254
Sheet3

Cell Formulas
Range	Formula
C2	C2	=6977835.66/1000
C3	C3	=51131.07/1000
C4	C4	=83389.14/1000
B2:B37	B2	=A2/1000

 

[Fluff]

For 365, how about

=LET(a,FORMULATEXT(B2),m,FIND("/",a),REPLACE(a,2,m-2,INDIRECT(MID(a,2,m-2))))

 

[Sufiyan97]

Than you very much Fluff, it works,

Is there any way to do it in Office 2013?

 

[Fluff]

Yes, it's just a bit longer

=REPLACE(FORMULATEXT(B2),2,FIND("/",FORMULATEXT(B2))-2,INDIRECT(MID(FORMULATEXT(B2),2,FIND("/",FORMULATEXT(B2))-2)))