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 |
Problem with fraction showing up as date when copied
Perhaps something like a single apostrophe at the beginning will work. NUMBA = "'" & NUMBA Stev -- shie ----------------------------------------------------------------------- shieb's Profile: http://www.excelforum.com/member.php...fo&userid=1640 View this thread: http://www.excelforum.com/showthread.php?threadid=31950 |
Problem with fraction showing up as date when copied
Steve, great job. Thanks a lot, works like a charm. Thanks to you as well Jim. -- Zeroman ------------------------------------------------------------------------ Zeroman's Profile: http://www.excelforum.com/member.php...o&userid=16628 View this thread: http://www.excelforum.com/showthread...hreadid=319505 |
All times are GMT +1. The time now is 01:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com