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?
Sorry, last post was a little unclear
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(C7;4) =CONCATENATE(B7;D7)
where "n" is the row number
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
