Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell value rounded to the tenth!
Hello everyone,
1. I have cell Q2 is the sum of many cells. How do I rounded thi cell value to the nearest tenth? 2. How do I incert auto date in a cell? 3. In *sheet 1* , I have Last name in cell A1 and First name in cel A2. I would like to have both first and last name appears in cell B1 o *sheet 2*. How Do I do this? I appreciate any help! Regards, Kim-An -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell value rounded to the tenth!
One way:
1. =ROUND(SUM(...), 1) 2. =TODAY() 3. =Sheet1!A2 & " " & Sheet1!A1 In article , Kim-Anh Tran wrote: Hello everyone, 1. I have cell Q2 is the sum of many cells. How do I rounded this cell value to the nearest tenth? 2. How do I incert auto date in a cell? 3. In *sheet 1* , I have Last name in cell A1 and First name in cell A2. I would like to have both first and last name appears in cell B1 of *sheet 2*. How Do I do this? I appreciate any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add rounded numbers using the rounded value | Excel Discussion (Misc queries) | |||
how to display rounded number in a cell w/formula | Excel Discussion (Misc queries) | |||
Check if rounded cell values fall within a range | Excel Discussion (Misc queries) | |||
Need formula to have date in cell B2 rounded to first of next mont | Excel Worksheet Functions | |||
one-tenth of a second delay | Excel Programming |