Turn fraction around

[PabloFer]

Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1

 

[sandy666]

You've XL365 so you've Power Query (Get&Transform) built-in

 

[Rick Rothstein]

For your posted attachment, what is in cell L5... a formula? If so, show it to us.

 

[Joe4]

So is column L the one you want to flip?
As Rick asked, we need to know what that formula is.

 

[etaf]

can you post a sample using
XL2BB
OR attach a file dropbox or onedrive I tend to open rather than unknown file sharing sites

 

[PabloFer]

I am trying to install XL2BB but having some troubles, please see the formula I have in the field I need to convert is in column L a simply division of column J and F

 

[Rick Rothstein]

So why isn't this formula the one you want to use then....

=F4/J4

 

[sandy666]

sndt4db71
	A	B	C	D	E	F	G	H	I	J	K	L
1	5/8	INTAKE NEEDED		INDOC		ACTUAL	REQ					Ratio
2
3	31-Aug	17	25	23	2	371	435	13
4	7-Sep	17	20	16	4	385	412	13	254	131	=J4/F4	1/3
5	14-Sep	18	15	12	3	394	412	13	254	143	36%	1/3
6	21-Sep	20		20	-20	434	412	13	255	163	38%	3/8
7	28-Sep	16		20	-20	474	412	13	256	183	39%	2/5
8	5-Oct	15		20	-20	514	493	13	257	203	39%	2/5
9	12-Oct	15		20	-20	554	493	13	258	223	40%	2/5
10	19-Oct	15		20	-20	594	493	13	259	243	41%	2/5
11	26-Oct	15		20	-20	634	493	13	260	263	41%	2/5
12	2-Nov	15		20	-20	674	560	15	261	283	42%	3/7
13	9-Nov	15		20	-20	714	560	15	262	303	42%	3/7
14	16-Nov	15		20	-20	754	560	15	263	323	43%	3/7
15	23-Nov	0		0	0	754	560	15	264	323	43%	3/7
16	30-Nov	0		0	0	754	560	15	265	323	43%	3/7
17	7-Dec	15		20	-20	794	624	16	266	343	43%	3/7
18	14-Dec			20	-20	834	624	16	267	363	44%	3/7
19	21-Dec			0	0	834	624	16	268	363	44%	3/7
Sheet1

 

[PabloFer]

So why isn't this formula the one you want to use then....

=F4/J4

J4/F4 it works as it should the result is 1/3, but I need to present as 3/1, I need to change the denominator to the numerator

 

[etaf]

thats in K4 not whats in L4
what format is the cell ?

 

[etaf]

when i copy into a spreadsheet I get a DATE, changed format in L to general

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
3	5-Aug	INTAKE NEEDED		INDOC		ACTUAL	REQ					Ratio
4
5	31-Aug	17	25	23	2	371	435	13
6	7-Sep	17	20	16	4	385	412	13	254	131	#DIV/0!	43891
7	14-Sep	18	15	12	3	394	412	13	254	143	0.36	43891
8	21-Sep	20		20	-20	434	412	13	255	163	0.38	44046
9	28-Sep	16		20	-20	474	412	13	256	183	0.39	43953
10	5-Oct	15		20	-20	514	493	13	257	203	0.39	43953
11	12-Oct	15		20	-20	554	493	13	258	223	0.4	43953
12	19-Oct	15		20	-20	594	493	13	259	243	0.41	43953
13	26-Oct	15		20	-20	634	493	13	260	263	0.41	43953
14	2-Nov	15		20	-20	674	560	15	261	283	0.42	44015
15	9-Nov	15		20	-20	714	560	15	262	303	0.42	44015
16	16-Nov	15		20	-20	754	560	15	263	323	0.43	44015
17	23-Nov	0		0	0	754	560	15	264	323	0.43	44015
18	30-Nov	0		0	0	754	560	15	265	323	0.43	44015
19	7-Dec	15		20	-20	794	624	16	266	343	0.43	44015
20	14-Dec			20	-20	834	624	16	267	363	0.44	44015
21	21-Dec			0	0	834	624	16	268	363	0.44	44015
Sheet1

Cell Formulas
Range	Formula
K6	K6	=J4/F4