ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   divide cells (https://www.excelbanter.com/excel-worksheet-functions/222191-divide-cells.html)

Maggi

divide cells
 
I need to show 2 different amounts in a single cell eg 7.5 and 5.5 as hours
worked for same day.
Using Office 2007 and Vista



Max

divide cells
 
Don't do that, irrespective of your Excel ver. Use 2 separate cells, one for
each figure. Much easier to calculate whatever-that-may-be-required based on
these figures later.

If you want to break for a new line within a cell,
just press Alt+ENTER at the breakpoint
("like a hard carriage return")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Maggi" wrote:
I need to show 2 different amounts in a single cell eg 7.5 and 5.5 as hours
worked for same day.
Using Office 2007 and Vista




All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com