Impossible formatting?

Occasional Visitor

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!

Related Conversations
Cell Validation - Drop Down Lists and Text Formatting
JenSmith in Excel on
1 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Relative conditional formatting
melissach in Excel on
8 Replies
Column Formatting - Render html
TrevorStyler in SharePoint on
0 Replies