Formatting Cell 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.

 

[Niek Otten]

Please don't multi-post
You have an answer in your other thread

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