<Format<Cells
Click on "Number" tab
Click on "Custom"
Enter this:
000000000.000000000
Add/Take away 0's to fit your needs.
--
Regards,
Dave
"kwiklearner" wrote:
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?
--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=520601