formatting cells fractions - HELP

[Twicebest]

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.

 

[Jim Thomlinson]

Change the fractions from Quarters to Up to 2 Digits.

 

[PCLIVE]

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

HTH,
Paul

 

[Twicebest]

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

Thanks though....

 

[Twicebest]

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

 

[PCLIVE]

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]

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]

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



--