Posted to microsoft.public.excel.misc

Twicebest

external usenet poster

Posts: 5

formatting cells 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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting Numbers and Fractions in Excel	monarcabak	Excel Discussion (Misc queries)	3	November 28th 06 03:09 AM
CONCATENATE Cells Formated as fractions	Northcoast	Excel Worksheet Functions	4	April 27th 06 05:24 PM
about fractions	patrick	Excel Discussion (Misc queries)	4	March 30th 06 03:27 AM
Fractions	V	Excel Discussion (Misc queries)	5	September 14th 05 04:00 PM
Conditional Formatting Multiple cells based on 2 cells	Louis Markowski	Excel Worksheet Functions	2	June 1st 05 05:26 PM

All times are GMT +1. The time now is 03:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us