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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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