Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fractions show as dates
My fractions show as dates. Can you advise on this, please? I appreciate
this newsgroup. Dick Ross |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fractions show as dates
When you first enter it put a 0 before the fraction, i.e. to enter 7/16 enter
it exactly like this: 0 7/16 This will tell excel you're entering a numerical fraction instead of a date. -- Regards, Dave "ross" wrote: My fractions show as dates. Can you advise on this, please? I appreciate this newsgroup. Dick Ross |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fractions show as dates
First select a cell or cells
Pull-down: Format Cells... Number Fraction then select a type Then enter the value. -- Gary's Student "ross" wrote: My fractions show as dates. Can you advise on this, please? I appreciate this newsgroup. Dick Ross |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fractions show as dates
"ross" wrote in message ... My fractions show as dates. Can you advise on this, please? I appreciate this newsgroup. Dick Ross From the Excel 2000 help system - see below. As with some other cell formats, this one seems to only work (or work most often) if the formatting is done before the data is entered. Show numbers as fractions 1.. Select the cells you want to format. 2.. On the Format menu, click Cells, and then click the Number tab. Show Me 3.. In the Category list, click Fraction, and then click the type of fraction you want to use. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fractions show as dates
When you enter a fraction in an unformatted cell, you'll need to enter
the = sign before the numbers. If you enter 1/2 by itself, Excel assumes you mean to enter a date, and "helpfully" formats the cell for you as a date. To enter the fractional amount "one half" you enter a formula, =1/2 to have Excel represent a numerical value. Since your cells may be inadvertently formatted as dates, you may need to reformat them to show numeric values. You can format the output to read as "1/2" instead of "0.5" as well. Additionally, you can format the cells in advance as Fractions and after that you can enter 1/2 (without the = sign), and the entry will be numeric. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fractions show as dates
Thanks for the great response. I have found that if I add an ' before the
fraction that I have what I need. Thanks again, Dick Ross "ross" wrote in message ... My fractions show as dates. Can you advise on this, please? I appreciate this newsgroup. Dick Ross |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fractions show as dates
That will absolutely work- as long as you need it for screen display
purposes only. If you try to convert that back to a numeric value using a formula such as =VALUE(A1) where the value in A1 is '1/2 Excel converts it to a date again, and you're back to the original problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a commission chart based on dates worked? | Excel Worksheet Functions | |||
US dates to UK?? | Excel Worksheet Functions | |||
How do I automatically show passed dates in red in Excel, please | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
How do I keep excel 2002 from changing fractions to dates? | Excel Discussion (Misc queries) |