Thread: Change from General Format to number format
View Single Post
 
Old 08-16-2013, 11:59 AM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
  
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Change from General Format to number format
Pecoflyer,
I did find a formula that works also,
=LEFT(A1,LEN(A2)*1)*1

I like your method better, it's quicker.

Thanks for your help!!!
Reply With Quote