Re: formatting cells fractions - HELP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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 work*** 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" <Twicebest@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E57839C-8698-449D-B8CA-1FA91FD24CBD@xxxxxxxxxxxxxxxx
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" <Twicebest@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48825004-65B3-4C10-9095-0EFE64E0782A@xxxxxxxxxxxxxxxx
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" <Twicebest@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DAE9E8BE-8F02-43EF-B2D9-1DA7E9FBB601@xxxxxxxxxxxxxxxx
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.










.

Quantcast