#.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

#.000"''" to show as 0.125"
 

Change the # sign to a zero (and I tend to inject constants that have
meaning in the format pattern by preceding it with a backslash).

Try this custom format... 0.000\"

Rick



"EXCEL NEWS" wrote in message
...
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

#.000"''" to show as 0.125"
 

On Apr 4, 10:59 pm, EXCEL$B!!(BNEWS wrote:
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

Try 0.000'' ?

Chris

#.000"''" to show as 0.125"
 

thanks to Rick and Chris
"cht13er" wrote in message
...
On Apr 4, 10:59 pm, EXCEL$B!!(BNEWS wrote:
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

Try 0.000'' ?

Chris