Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel fraction not a date
Windows 2000, Excel 2003
How do you get excel to use a fraction as a fraction and not a date? I am using a function that returns a fraction as a string. I then copy it and paste it in a new cell as value.. I have tried formating the cell as a decimal, as a fraction, it just keeps it as text or views it as a date.... any help would be appreciated. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel fraction not a date
It does not matter if its VBA or on the worksheet:
Sub frac() Selection.Formula = "= 1/4" Selection.Value = Selection.Value End Sub The space makes it a fraction and not a date. Format the cell to carrry the proper number of digits in the numerator and denominator. -- Gary''s Student - gsnu200724 "FGM" wrote: Windows 2000, Excel 2003 How do you get excel to use a fraction as a fraction and not a date? I am using a function that returns a fraction as a string. I then copy it and paste it in a new cell as value.. I have tried formating the cell as a decimal, as a fraction, it just keeps it as text or views it as a date.... any help would be appreciated. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel fraction not a date
I think you would need to evaluate the fraction as a decimal and place that
in a cell. then format the cell as fraction. It is unclear whether you are doing the copying with code or manually. If manual, I can select the fraction in the formula bar and do ctrl+V, go to the new cell and select it. Go to the formula bar and enter = then ctrl+C and hit enter. Format the cell as fraction. -- Regards, Tom Ogilvy "FGM" wrote: Windows 2000, Excel 2003 How do you get excel to use a fraction as a fraction and not a date? I am using a function that returns a fraction as a string. I then copy it and paste it in a new cell as value.. I have tried formating the cell as a decimal, as a fraction, it just keeps it as text or views it as a date.... any help would be appreciated. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel fraction not a date
The equal sign makes it a fraction. The below works fine for me.
Sub frac() Selection.Formula = "=1/4" Selection.Value = Selection.Value End Sub as does manual entry =1/4 This could be affected by the settings in the transition tab of tools=options. -- Regards, Tom Ogilvy "Gary''s Student" wrote: It does not matter if its VBA or on the worksheet: Sub frac() Selection.Formula = "= 1/4" Selection.Value = Selection.Value End Sub The space makes it a fraction and not a date. Format the cell to carrry the proper number of digits in the numerator and denominator. -- Gary''s Student - gsnu200724 "FGM" wrote: Windows 2000, Excel 2003 How do you get excel to use a fraction as a fraction and not a date? I am using a function that returns a fraction as a string. I then copy it and paste it in a new cell as value.. I have tried formating the cell as a decimal, as a fraction, it just keeps it as text or views it as a date.... any help would be appreciated. Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel fraction not a date
Hi,
Here's one way - select the range and choose the command Format, Cells, Number tab, Fraction and pick a format of your choice. Then enter the number as fractions. -- Cheers, Shane Devenshire "FGM" wrote: Windows 2000, Excel 2003 How do you get excel to use a fraction as a fraction and not a date? I am using a function that returns a fraction as a string. I then copy it and paste it in a new cell as value.. I have tried formating the cell as a decimal, as a fraction, it just keeps it as text or views it as a date.... any help would be appreciated. Thanks. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel fraction not a date
Thank you
-- Gary''s Student - gsnu200724 "Tom Ogilvy" wrote: The equal sign makes it a fraction. The below works fine for me. Sub frac() Selection.Formula = "=1/4" Selection.Value = Selection.Value End Sub as does manual entry =1/4 This could be affected by the settings in the transition tab of tools=options. -- Regards, Tom Ogilvy "Gary''s Student" wrote: It does not matter if its VBA or on the worksheet: Sub frac() Selection.Formula = "= 1/4" Selection.Value = Selection.Value End Sub The space makes it a fraction and not a date. Format the cell to carrry the proper number of digits in the numerator and denominator. -- Gary''s Student - gsnu200724 "FGM" wrote: Windows 2000, Excel 2003 How do you get excel to use a fraction as a fraction and not a date? I am using a function that returns a fraction as a string. I then copy it and paste it in a new cell as value.. I have tried formating the cell as a decimal, as a fraction, it just keeps it as text or views it as a date.... any help would be appreciated. Thanks. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel fraction not a date
I did say that it was a function.
dec2frac = LTrim(Str(intNumerator)) & "/" & LTrim(Str(intDenominator)) ' Display the numerator and denominator This came from Erik Oosterwal..... He said to copy and paste it as a value but that does not work on mine. Adding = "= " & the above puts an = sign as text even when I format the field. My long way of finally doing it and it is not a good answer was in the cell below formatted as a fraction. =VALUE(LEFT(B6,FIND("/",B6,1)-1))/VALUE(MID(B6,FIND("/",B6,1)+1,10)) Thank you and I can try a sub that calls the function and puts in the Selection.Formula = "= X" Selection.Value = Selection.Value Thanks again "Gary''s Student" wrote: It does not matter if its VBA or on the worksheet: Sub frac() Selection.Formula = "= 1/4" Selection.Value = Selection.Value End Sub The space makes it a fraction and not a date. Format the cell to carrry the proper number of digits in the numerator and denominator. -- Gary''s Student - gsnu200724 "FGM" wrote: Windows 2000, Excel 2003 How do you get excel to use a fraction as a fraction and not a date? I am using a function that returns a fraction as a string. I then copy it and paste it in a new cell as value.. I have tried formating the cell as a decimal, as a fraction, it just keeps it as text or views it as a date.... any help would be appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fraction into date | Excel Discussion (Misc queries) | |||
fraction into date | Excel Discussion (Misc queries) | |||
How do I convert a fraction to its true decimal, not a date no. | Excel Discussion (Misc queries) | |||
date has fraction instead of whole number | Excel Discussion (Misc queries) | |||
fraction getting convered into date | New Users to Excel |