Long time reader, first time asker (read: I tried searching but could not
find the answer):
I have cells that have 4 digit numbers (e.g. 0034) and they need to be
formatted to the 00.00 format (end result: 00.34).

The issue is they were imported from an external data source, so all the
numbers are in Excel as text. When they are converted over to numbers, the
zeroes are dropped, so it ends up being 34. When I apply 00.00 formatting,
or =TEXT(A2,"00.00") or the other methods of keeping leading zeroes, the
number is 34.00, because it takes and tacks the number on the front.

Is there a way to convert these to numbers into the 00.00 format?