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.

Change the fractions from Quarters to Up to 2 Digits.
--
HTH...

Jim Thomlinson


"Twicebest" wrote:

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.

I could do that... But i need all my numbers to show either as quarters or
half...
that is my problem.

Thanks though....

"Jim Thomlinson" wrote:

Change the fractions from Quarters to Up to 2 Digits.
--
HTH...

Jim Thomlinson


"Twicebest" wrote:

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.

Set your formatting to "Up to one digit (1/4)".

HTH,
Paul

--

"Twicebest" wrote in message
...
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.

I tried that too... But then i got 1/7, 2/5, 5/7... this is giving me a hard
time to fix...



"PCLIVE" wrote:

Set your formatting to "Up to one digit (1/4)".

HTH,
Paul

--

"Twicebest" wrote in message
...
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.

You could use a formula in another cell.
With you number in A1:

=ROUND(A1/0.25,0)*0.25
Note: This will change the actual number.

If your original numbers are results from formulas, then you could adapt the
above formula into it if that works for you.

Regards,
Paul

--

"Twicebest" wrote in message
...
I tried that too... But then i got 1/7, 2/5, 5/7... this is giving me a
hard
time to fix...



"PCLIVE" wrote:

Set your formatting to "Up to one digit (1/4)".

HTH,
Paul

--

"Twicebest" wrote in message
...
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.

That would be a good idea... But i wanted to find a way to format the cells
because to work with formulas would be a pain for I have thousands of numbers
to work with.

Its a good idea though. If I can't find a way to format the cells for
quarters and halves I guess I won't have many choices.

thanks...

"PCLIVE" wrote:

You could use a formula in another cell.
With you number in A1:

=ROUND(A1/0.25,0)*0.25
Note: This will change the actual number.

If your original numbers are results from formulas, then you could adapt the
above formula into it if that works for you.

Regards,
Paul

--

"Twicebest" wrote in message
...
I tried that too... But then i got 1/7, 2/5, 5/7... this is giving me a
hard
time to fix...



"PCLIVE" wrote:

Set your formatting to "Up to one digit (1/4)".

HTH,
Paul

--

"Twicebest" wrote in message
...
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.

You could use VBA to convert the numbers to the results of the ROUND
formula. This will eliminate the need to use additional cells for
calculations, in addition to not having to bog down your worksheet with
formulas.
Just adjust your range as needed.

Sub test()

For Each cell In Range("A1:A5")
cell.Value = WorksheetFunction.Round(cell.Value / 0.25, 0) * 0.25
Next cell

End Sub



--

"Twicebest" wrote in message
...
That would be a good idea... But i wanted to find a way to format the
cells
because to work with formulas would be a pain for I have thousands of
numbers
to work with.

Its a good idea though. If I can't find a way to format the cells for
quarters and halves I guess I won't have many choices.

thanks...

"PCLIVE" wrote:

You could use a formula in another cell.
With you number in A1:

=ROUND(A1/0.25,0)*0.25
Note: This will change the actual number.

If your original numbers are results from formulas, then you could adapt
the
above formula into it if that works for you.

Regards,
Paul

--

"Twicebest" wrote in message
...
I tried that too... But then i got 1/7, 2/5, 5/7... this is giving me a
hard
time to fix...



"PCLIVE" wrote:

Set your formatting to "Up to one digit (1/4)".

HTH,
Paul

--

"Twicebest" wrote in message
...
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.