| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format issue to linked cells
Hi,
All the following cells are formatted at standard Numeric, 2 decimal places. I have 2 cellsC2 and D2 and type in the value of 80.60. I use =SUM(C2:D2) in Cell E2 - the result in Cell E2 is 161.20 (of course!!). OK, now I reference a field in another worksheet with the same values so, C2 & D2 now read =Data!F14 (where Data!F14 has the value of 80.60). c2 & d2 DISPLAY 80.60. However, Cell E2 now displays 161.19. Can anyone help??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping text format in linked cells | Excel Worksheet Functions | |||
| Obscure issue - recalculating linked pictures! | Excel Discussion (Misc queries) | |||
| HOW DO I KEEP THE SAME FORMAT IN LINKED CELLS ? | Excel Discussion (Misc queries) | |||
| How do I format linked cells? | Excel Discussion (Misc queries) | |||
| Format cells (number) issue | Excel Discussion (Misc queries) | |||
Threaded Mode
