Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting cells fractions - HELP | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Formatting Numbers and Fractions in Excel | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) |