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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
