View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EXCEL NEWS EXCEL NEWS is offline
external usenet poster
 
Posts: 43
Default #.000"''" to show as 0.125"

hi,

i make the cell format to be #.000"''" ,

so when the input is ,for instance 12.352 ,it is shown as 12.352'',

but when i input 0.352 ,it is shown as .352'',

how to make it to be shown as 0.352''

thanks