When i put a text of a ratio e.g. "1/2" Excel automatically converts it into the corresponding date (e.g. 2 - Jan) although i had chosen the format to be general and not a date. When i try to make it into a general cell again, there it gives me the corresponding number but not the ratio. I know that i can keep the text form if i put something else before the ratio (e.g. " 1/2" instead of "1/2") the problem is that i need it to be without anything extra because it will be the input for another program, which requires (i think) the exact expression ( i suppose that if something like that can't be done, then might not be a problem with the program if a put "something extra" before the ratio.
2007-12-10 08:30:55 · 7 answers · asked by tzolakas 1 in Computers & Internet ➔ Programming & Design
right click on the cell and choose format cell, then you will see the sample number "1/2" on top, choose different formats until it gets what you want. The TEXT selection would work great here.
Good luck.
2007-12-10 08:37:28 · answer #1 · answered by wolfance 3 · 1⤊ 2⤋
That is basically a formula...add an = before it:
=1/2
Then format the number format of the cell to fraction.
2007-12-10 08:45:59 · answer #2 · answered by Jake 3 · 1⤊ 0⤋
If you want 0.5.. then it will be =1/2
If you want it to show "1/2" then preceed it with a '
That is the key usually located between the semicolon, colon key and your enter/return button
So it'd be '1/2 This will disregard the auto-format.
2007-12-10 09:29:51 · answer #3 · answered by bahamutxd 3 · 0⤊ 1⤋
Hi,
Type a zero, a space, and then 1/2
0 1/2
-Jim Gordon
Microsoft Mac MVP
MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/
2007-12-10 16:04:24 · answer #4 · answered by jimgmacmvp 7 · 0⤊ 1⤋
Why not format the cell as a Fraction?
2007-12-10 08:37:10 · answer #5 · answered by vstar_in_texas 3 · 0⤊ 1⤋
Write it as .5
2007-12-10 08:48:56 · answer #6 · answered by Anonymous · 0⤊ 2⤋
.
2016-04-08 06:29:27 · answer #7 · answered by Anonymous · 0⤊ 0⤋