Forum Discussion
Building UPC in Excel - issue is keeping leading zeros and eliminating spaces between the numbers
am building UPC codes using data imported into Excel. When copying this data over to a new column to create the UPC codes, I need to keep the leading 0's but eliminate the spaces between the columns....
stephanie07 With regard to loosing all formulae upon saving I suspect that you open the TXT file created by Notes, enter your formulae and save it without changing the file type to an Excel Workbook (i.e. XLSX). Then you save the workbook back to a flat text file, i.e. without the formulae. Just the result of these formulae are save as text.
Good thought, that would do it.