[EMAIL PROTECTED] said the following on 24/9/2005 11:57 PM:
Dan: Thanks for your help. I do have a follow-up question though. When I
take the cell that has 56.0540 in it, formatted with 4 decimal places, and
change the formatting to text, it comes out as 56.05. Is there any way I can
change to formatting to text and preserve the 4 decimal places?
I do know that I can first format a cell to text, then type in 56.0540, and
that's what it will be. But it would be very desirable if I could re-format
the cells to text and somehow have all of the decimal places preserved, without
retyping in all of the numbers.
Thanks again,
Dick, Webster NY
In a message dated 9/23/2005 9:36:59 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
On Friday 23 September 2005 04:50 pm, [EMAIL PROTECTED] wrote:
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?
Concatenate combines two texts into one. As you have found out, you
can run into problems when you combine a text with a number.
If you format the second cell as text before entering the number,
concatenate will work as it should: the answer is "Jan56.0540". If you
are going to be concatenate two columns in which one column is text and
the second column is numbers, format the entire second column as text
before entering the numbers.
Dan
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
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]
