On Saturday 24 September 2005 10:38 am, Brian wrote:
> Brian said the following on 25/9/2005 1:19 AM:
> >>>> When I concatenate two cells, containing "Jan" in one, and
> >>>> "56.0540" (as a numerical format, with 4 decimal places), I
> >>>> get: "Jan56.054".
> >>>>
> >>>> I would like it to display as "Jan56.0540" (with the trailing
> >>>> zero).
> >>>>
> >>>> I have tried a number of things but cannot figure out how to
> >>>> get this to happen. Any suggestions?
>
> Still a bit rough, and in error ..... let's try again
>
>
> Try this multi-stage process...
> .. convert number to FIXED with 4 decimal places (Col C)
> .. CONCATENATE text (Col A) and fixed number (Col C)
>
> A B C D
> 1 Jan 56.045 56.0450 Jan56.0450
> 2 Feb 19.23 19.2300 Feb19.2300
> 3 March 21.1234 21.1234 March21.1234
> 4 April 1.001 1.0010 April1.0010
>
> Formula =FIXED(Bn;4) =CONCATENATE(An;Cn)
>
> where "n" is the row number
>
>
> Brian
If you have numbers that have a thousands seperator [comma] (such as
4,236.5490), you can preserve the comma by changing the formula to
=FIXED(Bn;4;0). It produces this result
A B C D
1 May 4,236.5490 4,236.5490 May4,236.5490
=FIXED(Bn;4;0) =CONCATENATE(An;Cn)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
