PC Review


Reply
Thread Tools Rate Thread

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

 
 
EXCEL NEWS
Guest
Posts: n/a
 
      5th Apr 2008
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
 
Reply With Quote
 
 
 
 
Rick Rothstein \(MVP - VB\)
Guest
Posts: n/a
 
      5th Apr 2008
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


 
Reply With Quote
 
cht13er
Guest
Posts: n/a
 
      5th Apr 2008
On Apr 4, 10:59 pm, EXCEL NEWS <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
 
Reply With Quote
 
EXCEL NEWS
Guest
Posts: n/a
 
      5th Apr 2008
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 NEWS <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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Field Names: "LongName", "ShortName", "Code", "Description","Comments" PeteCresswell Microsoft Access 2 25th Feb 2009 11:41 PM
if a field contains "vita" or "acid" , show "YES" to the result co ali Microsoft Access Queries 4 29th Nov 2007 06:51 PM
Include "Telecommuting" or "Teleworking" as a "Show time as" statu =?Utf-8?B?R29yZG9uIEdyZWVuZQ==?= Microsoft Outlook Calendar 0 31st Jul 2006 03:37 PM
<FORM METHOD="post" onSubmit="return fieldcheck()" name="orientation" action="http://ws-kitty.BU.edu/AT/survey/orientation/script/write.asp" language="JavaScript"> Joeyej Microsoft ASP .NET 0 4th Jun 2004 08:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:15 AM.