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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

On Apr 4, 10:59 pm, EXCEL$B!!(BNEWS <youngma...@hotmail.com> 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

thanks to Rick and Chris
"cht13er" <(E-Mail Removed)> wrote in message
news:a3ee6baf-3cbe-4772-96bd-(E-Mail Removed)...
> On Apr 4, 10:59 pm, EXCEL$B!!(BNEWS <youngma...@hotmail.com> 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