| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to show repeating decimals line
Hi all, is there a way to show the line over the repeating decimal?
For example, if I change a cell to a decimal format, type in 1/3 and press enter I get 0.333333333etc. If I were handwriting it I could represent the decimal as 0.3 with a line over the 3. Is there a way to do that in Excel for repeating decimals? There are other fractions that when converted are repeating decimals as well. Thanks! -Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show decimals only when needed | Excel Discussion (Misc queries) | |||
| only show decimals | Excel Discussion (Misc queries) | |||
| How do I show only the whole number w/o eliminating four decimals? | Excel Worksheet Functions | |||
| How to only show decimals if there are any | Excel Discussion (Misc queries) | |||
| How do I remove repeating line in Excell - Top line on each page.. | Excel Worksheet Functions | |||
Threaded Mode
