Formatting Cell Fractions... HELP
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. |
Formatting Cell Fractions... HELP
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. | | |
All times are GMT +1. The time now is 07:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com