| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with fraction showing up as date when copied
Him Jim, Thanks for replying. Yes I am trying to code this in VBA. I trie what you said and it still comes out as Mar-4. The easiest way to fi this is by selecting the cell before I copy to it and convert it unde "format cells" to custom. But I want to find a way to code it becaus the worksheet that I am copying the 3/4 to may not even exist -- Zeroma ----------------------------------------------------------------------- Zeroman's Profile: http://www.excelforum.com/member.php...fo&userid=1662 View this thread: http://www.excelforum.com/showthread.php?threadid=31950 |
| 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) | |||
| values not showing for copied formulas | Excel Worksheet Functions | |||
| How do I stop totals showing from a copied formula? | Excel Discussion (Misc queries) | |||
| date has fraction instead of whole number | Excel Discussion (Misc queries) | |||
![Zeroman[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
