|Microsoft Excel Help: |
I need to format 20121231 as 12/31/2012. I have about 5,000 rows that are in the former format that I need to convert to the latter. The custom formatting in excel didn't help, because it didn't recognize the number as anything other than a number.
Someone asked this question on this forum in 2005, and someone recommended the following "formula" =LEFT(A1,4)&"/"&(MID(A1,5,2)&"/"&RIGHT(A1,2)). This apparently worked for the individual. I just don't know what to do with this formula.
I do not know the first thing about VBA, but have heard that I need to use it to solve my problem.