Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert fraction to decimal
Is there anyway in Excel to format a cell so if the user types 61/4 it will
convert to 6.25? If not what is the best way to create a conversion so the user can type in 51/2 and have 5.5 show up, either in another cell or in the same cell? Thanks for the help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert fraction to decimal
In a separate cell enter:
=LEFT(A1,1)+MID(A1,2,1)/RIGHT(A1,1) This works for very simple cases, but if you have something like: 111/25 we can't tell if its 11 & 1/25 or 1 & 11/25 -- Gary''s Student - gsnu200731 "Dig" wrote: Is there anyway in Excel to format a cell so if the user types 61/4 it will convert to 6.25? If not what is the best way to create a conversion so the user can type in 51/2 and have 5.5 show up, either in another cell or in the same cell? Thanks for the help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert fraction to decimal
Dig,
One possibility is to first format the cell as a number, such as with Format - Cells - Number - Number. Now the automatic formatting to fraction number formatting when the user types 6 1/4 won't occur. The problem is that you'll get fixed decimal place, unlike General. We all wish we could disable automatic formatting for cells. We think they're going to do that in 2057. If that isn't satisfactory, an event-fired macro could automatically reformat it after the user types in the 6 1/4. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Dig" wrote in message ... Is there anyway in Excel to format a cell so if the user types 61/4 it will convert to 6.25? If not what is the best way to create a conversion so the user can type in 51/2 and have 5.5 show up, either in another cell or in the same cell? Thanks for the help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert fraction to decimal
Maybe use a custom format that returns the same as General e.g.
General;-General so that it doesn't autoformat to a fraction format. On 19 Jun, 17:18, "Earl Kiosterud" wrote: Dig, One possibility is to first format the cell as a number, such as with Format - Cells - Number - Number. Now the automatic formatting to fraction number formatting when the user types 6 1/4 won't occur. The problem is that you'll get fixed decimal place, unlike General. We all wish we could disable automatic formatting for cells. We think they're going to do that in 2057. If that isn't satisfactory, an event-fired macro could automatically reformat it after the user types in the 6 1/4. -- Earl Kiosterudwww.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... -----------------------------------------------------------------------"Dig" wrote in message ... Is there anyway in Excel to format a cell so if the user types 61/4 it will convert to 6.25? If not what is the best way to create a conversion so the user can type in 51/2 and have 5.5 show up, either in another cell or in the same cell? Thanks for the help- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leave the decimal fraction | Excel Worksheet Functions | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
formula for converting decimal to inch & fraction | Excel Discussion (Misc queries) | |||
convert decimal to inch & fraction | Excel Discussion (Misc queries) | |||
How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions |