|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 26th, 2009, 05:26 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help with displaying 0's after decimals
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 
|
|
#2
August 26th, 2009, 05:33 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with displaying 0's after decimals
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
|
|
#3
August 26th, 2009, 05:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with displaying 0's after decimals
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
