Excel text and number format, cant get all the same
Posted on 2014-07-23
I have a price list that was created by exporting part numbers from SQL via Access, this was copy pasted to excel, some of the part numbers end with trailing zero's 0712.03000 for example. those numbers exported and put in this excel file are ok for what we are trying to do, but at one point the excel file had some manipulation and the part numbers were manually typed 0712.03000, the numbers from the import all seem to be format as number with decimal at 5, but all have the green triangle icon except where someone typed in the number.
No matter how I try to format the cells when I try to concatenate adding a "REG" prefix, the trailing zeroes get stripped.
I have tried formatting the entire column to numbers, or text, still get the same results, I cant seem to force the formatting on those cells.