Format Values to specified length

K

kwiklearner

I have a list of values that I need to format to the specific format
below:
+000000010.12345678
However, the list of values have 10.1, 10.25.... how can I throw in the
extra 0 before and after the decimal?
 
D

David Billigmeier

<Format><Cells>
Click on "Number" tab
Click on "Custom"
Enter this:
000000000.000000000

Add/Take away 0's to fit your needs.
 
Top