View Single Post
 
Old 11-20-2013, 10:16 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I take it this value "261209-002" is text, not numeric, bremen22. If so, and supposing it's in G1, then I would use this formula:
Code:
=LEFT(G1,2)&"-"&MID(G1,3,1)&"0"
Reply With Quote