Fomat Cells Fractions

Fomat Cells Fractions - HELP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Twicebest - 28 Feb 2008 21:46 GMT

Using Excel I formatted cells using fractions as quarters. how can I convert
the 2/4 to 1/2 now?
all of the numbers of my cells now show either 1/4, 2/4 or 3/4. I wanted to
be able to change the 2/4 for 1/2 without having to format each one. Thank
you

Before I formatted the number showed 101.5, 102.8 - after formatting 101
2/4, 102 3/4. I was trying to find a way to change all the 2/4 for 1/2.

Reply to this Message

Niek Otten - 28 Feb 2008 22:43 GMT

Format Custom as # ?/?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Using Excel I formatted cells using fractions as quarters. how can I convert
| the 2/4 to 1/2 now?
[quoted text clipped - 4 lines]
| Before I formatted the number showed 101.5, 102.8 - after formatting 101
| 2/4, 102 3/4. I was trying to find a way to change all the 2/4 for 1/2.

Reply to this Message

Twicebest - 28 Feb 2008 22:52 GMT

I tried that but then I got 1/5, 4/5, 5/7...

I need all my numbers to be either quarters of half.

thanks for trying though.

> Format Custom as # ?/?
>
[quoted text clipped - 6 lines]
> | Before I formatted the number showed 101.5, 102.8 - after formatting 101
> | 2/4, 102 3/4. I was trying to find a way to change all the 2/4 for 1/2.

Reply to this Message

Tyro - 29 Feb 2008 00:01 GMT

Have you tried Format Cells/Fractions/As halves ?

Tyro

> Using Excel I formatted cells using fractions as quarters. how can I
> convert
[quoted text clipped - 6 lines]
> Before I formatted the number showed 101.5, 102.8 - after formatting 101
> 2/4, 102 3/4. I was trying to find a way to change all the 2/4 for 1/2.

Reply to this Message

Twicebest - 29 Feb 2008 00:09 GMT

yea... but i need my numbers to be in quarters and halves... if i change for
fractions/as halves i won't be able to use as quarters.

> Have you tried Format Cells/Fractions/As halves ?
>
[quoted text clipped - 10 lines]
> > Before I formatted the number showed 101.5, 102.8 - after formatting 101
> > 2/4, 102 3/4. I was trying to find a way to change all the 2/4 for 1/2.

Reply to this Message

Tyro - 29 Feb 2008 02:31 GMT

Formatting as halves has nothing to do with the underlying value in the
cells. Those values stay as is. They can be formatted as quarters, halves,
whatever. Formatting a number as something does not change the number, just
the presentation of the number.

Tyro
\

> yea... but i need my numbers to be in quarters and halves... if i change
> for
[quoted text clipped - 17 lines]
>> > 101
>> > 2/4, 102 3/4. I was trying to find a way to change all the 2/4 for 1/2.

Reply to this Message

Ron Rosenfeld - 29 Feb 2008 00:47 GMT

>Using Excel I formatted cells using fractions as quarters. how can I convert
>the 2/4 to 1/2 now?
[quoted text clipped - 4 lines]
>Before I formatted the number showed 101.5, 102.8 - after formatting 101
>2/4, 102 3/4. I was trying to find a way to change all the 2/4 for 1/2.

You will need to ROUND your cells to the nearest 1/4, then format as # ?/?
(fraction with up to one digit)

To round the cells,

=ROUND(your_formula/0.25,0)*0.25

--ron

Reply to this Message