It worked! Thanks very much! I was pretty sure there had to be a way to do it. Dick, Webster, NY In a message dated 9/24/2005 11:12:22 AM Eastern Daylight Time, [EMAIL PROTECTED] writes:
[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
