Thread: divide cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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