How can I get cell A1 to show trailing zeros?
I've entered =CONCATENATE(A1," inches")
When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches
I need those missing zeros!
THANKS
How can I get cell A1 to show trailing zeros?
I've entered =CONCATENATE(A1," inches")
When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches
I need those missing zeros!
THANKS
How about
=CONCATENATE(TEXT(A1,"0.000")," inches")
or
=TEXT(A1,"0.000") & " inches"
"dbizek" wrote:
> How can I get cell A1 to show trailing zeros?
>
> I've entered =CONCATENATE(A1," inches")
>
> When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches
>
> I need those missing zeros!
> THANKS
Alternatively, you can format cell A1 as CUSTOM
Type -> 0.000 "inches"
"Barb R." wrote:
> How about
>
> =CONCATENATE(TEXT(A1,"0.000")," inches")
>
> or
>
> =TEXT(A1,"0.000") & " inches"
>
> "dbizek" wrote:
>
> > How can I get cell A1 to show trailing zeros?
> >
> > I've entered =CONCATENATE(A1," inches")
> >
> > When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches
> >
> > I need those missing zeros!
> > THANKS
That works, thanks! How about this? Is there a way to contol the number of
decimal places in that string? IE if its 1.500 i'd like to show 1.50 but if
it's .060 i'd like to show .060 any ideas?
"Barb R." wrote:
> How about
>
> =CONCATENATE(TEXT(A1,"0.000")," inches")
>
> or
>
> =TEXT(A1,"0.000") & " inches"
>
> "dbizek" wrote:
>
> > How can I get cell A1 to show trailing zeros?
> >
> > I've entered =CONCATENATE(A1," inches")
> >
> > When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches
> >
> > I need those missing zeros!
> > THANKS
On Thu, 23 Jun 2005 09:56:04 -0700, dbizek <[email protected]>
wrote:
>That works, thanks! How about this? Is there a way to contol the number of
>decimal places in that string? IE if its 1.500 i'd like to show 1.50 but if
>it's .060 i'd like to show .060 any ideas?
>
>"Barb R." wrote:
Yes there is, but you will first have to state the rules by which you want to
determine the number of decimal places in the result.
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks