Avatar of jajen
Flag for United States of America

asked on 

Excel 2010 Formula

I need to take a column in Excel that has been formatted to have leading zeros and put "" around this number with a comma in between each number so I can copy these numbers into a Crystal report selection criteria.  I can do each of the tasks separately but if I add the " it removes the leading zero or I can add the , to get a row of these numbers but just can't find the way to successfully do all three things.  Can someone please help me with how to successfully do this.
Microsoft Excel

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon