Edit cell in Excel

pgarth

New Member

Join Date: Feb 2011

Posts: 2

20th Feb 2011

I have a column of numbers that represent time. However there is no ":" seperator. I need a macro that can place the colon appropriately. Example:

712 changes to 7:12
804 changes to 8:04
1456 changes to 14:56

« Select Items from a List | Novice Reqs Help Wiping Hard Drive »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel crashes when using F2 to edit a cell	folajinadu	Microsoft Excel Programming	0	14th Feb 2008 07:59 PM
How do I edit a cell in Excel without clicking on the cell first?	=?Utf-8?B?QWxpc2E=?=	Microsoft Excel Worksheet Functions	5	2nd Apr 2007 07:15 PM
How can i get an If formula in excel to edit another cell?	=?Utf-8?B?SmltbXkgSG9mZmE=?=	Microsoft Excel Worksheet Functions	2	16th Aug 2005 05:53 PM
Use VBA to open an Excel cell for Edit	Michael Gree	Microsoft Excel Programming	5	27th Oct 2003 02:38 AM
excel: Edit cell???	AL	Microsoft Excel Worksheet Functions	2	14th Oct 2003 09:42 PM