On Sun, 2005-09-25 at 01:38 +1000, 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
>
>
This might be what you want in column C:
=CONCATENATE(An;(FIXED(Bn;4))) where n is the row number
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
