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
