I have a column of data that is originally formatted in this way-> '0.1234' . Data was manually changed throughout a big portion of the column to a text format and the data inside was changed to the format of '.1234' removing the leading zero. I can reformat the entire column to "look" like its '.1234' but the data in the cell will still actually say '0.1234'. I've contacted everyone I know including microsofts helpdesk to figure this out but still no dice. Please help!