how display 12/3 as fraction?

[Ian Elliott]

Thanks in advance for any help.
I tried to display 12/3 as "12/3" in a cell by formating as fraction, with
up to 2 digits, but it just shows 4.
Any ideas on how to show as 12/3?
Thanks

 

[Luke M]

The basic fraction format for two numbers is actualy (look under custom)
# ??/??
you could modify this to:
??/??
however, XL uses its knowledge and will always try to reduce fractions, thus
12/3 would be displayed as 4/1.

If you really need to display 12/3, you will first need to format the cell
as text, before inputting your value.

 

[Niek Otten]

<will always try to reduce fractions>

Not always. Format Custom as ?/3

 

[Jacob Skaria]

Pre-format this to text
OR
Enter a space before

If this post helps click Yes

 

[DataFlunky]

Type a single apostrophe before "12/3" -- '12/3. The apostrophe will not
display, but it lets Excel know that the content is text.

 

[Ian Elliott]

thanks Niek, that worked the best-I didn't have to change text to values
afterwards.