View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default Format Values to specified length

<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