| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate the difference between two cells
Using formula
=a1-b1 The cell only displays the formula - - not the answer. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the difference between two cells
click on that cell
do format cells on the number tab (the first one), click category: general, OK (you will probably see it was formatted as text) then double click back into your cell, and press return. -- Allllen "jrivel" wrote: Using formula =a1-b1 The cell only displays the formula - - not the answer. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate the difference between two cells
Perfect - - Thanks very much.
"Allllen" wrote: click on that cell do format cells on the number tab (the first one), click category: general, OK (you will probably see it was formatted as text) then double click back into your cell, and press return. -- Allllen "jrivel" wrote: Using formula =a1-b1 The cell only displays the formula - - not the answer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| to calculate the difference between sign in and signout time in minutes. | Excel Worksheet Functions | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| Calculate Difference b/e 2 dates. | New Users to Excel | |||
| How do I only calculate cells which have a filled color format? | Excel Discussion (Misc queries) | |||
Linear Mode
