Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trouble with subtracting cells and adding text...
To get the 39.61 hours your cell must be formatted as number with two decimal
places. When you use the & in the cell you see the full formatting. If you format the cell with the 39.61 showing as having a lot more decimal places you will see the same as with the &. -- Gary''s Student "traybuddy" wrote: A1=4278.39 Q12=4318.00 MY FORMULA IS... =(Q12-A1)&"HRS" IAM GETTING ... 39.6099999999997HRS WHEN I SHOULD GET... 39.61HRS IT ONLY HAPPENS WHEN I PUT THE... &"HRS" AT THE END OF THE FORMULA... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up cells that include text in them | Excel Discussion (Misc queries) | |||
adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
Adding a lot of text to MS Excel cells | Excel Discussion (Misc queries) | |||
Adding two text cells together | Excel Discussion (Misc queries) | |||
Adding cells with numbers and text | Excel Worksheet Functions |