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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ian Elliott" wrote:

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

<will always try to reduce fractions

Not always. Format Custom as ?/3

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Luke M" wrote in message
...
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ian Elliott" wrote:

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

Pre-format this to text
OR
Enter a space before

If this post helps click Yes
---------------
Jacob Skaria


"Ian Elliott" wrote:

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

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" wrote:

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

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


"Niek Otten" wrote:

<will always try to reduce fractions

Not always. Format Custom as ?/3

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Luke M" wrote in message
...
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ian Elliott" wrote:

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