formatting cells fractions - HELP

T

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.
 
T

Twicebest

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

Thanks though....
 
T

Twicebest

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

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

--
 
T

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...
 
P

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



--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top