| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
