Hi,
I have 2 cells. One with the number that has 2 decimals and one with text.
When I use the "&" function to combine the 2 into 1 cell, all of the numbers
with the 0 at the end disappear. Example: cell 1: 3.80, cell 2: +80.
cell1&cell2 resulted in 3.8 +80 instead of 3.80 +80.
Any help would be appreciated.
mike

You'll have to provide the formatting:

=text(a1,"0.00")&...
same with dates and times, too
=...&text(a2,"mm/dd/yyyy")





mike wrote:

Hi,
I have 2 cells. One with the number that has 2 decimals and one with text.
When I use the "&" function to combine the 2 into 1 cell, all of the numbers
with the 0 at the end disappear. Example: cell 1: 3.80, cell 2: +80.
cell1&cell2 resulted in 3.8 +80 instead of 3.80 +80.
Any help would be appreciated.
mike

--

Dave Peterson

Thank you so much Dave.
I worked really well.
Mike

"Dave Peterson" wrote:

You'll have to provide the formatting:

=text(a1,"0.00")&...
same with dates and times, too
=...&text(a2,"mm/dd/yyyy")





mike wrote:

Hi,
I have 2 cells. One with the number that has 2 decimals and one with text.
When I use the "&" function to combine the 2 into 1 cell, all of the numbers
with the 0 at the end disappear. Example: cell 1: 3.80, cell 2: +80.
cell1&cell2 resulted in 3.8 +80 instead of 3.80 +80.
Any help would be appreciated.
mike

--

Dave Peterson