View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KRK KRK is offline
external usenet poster
 
Posts: 91
Default two integers in one cell

Hello, I have Excel 2007

I am developing a spreadsheet in which it might (repeat might) be helpful to
put 2 integers into a single cell, and to access them independently from
elsewhere. I strongly suspect this is impossible (and probably daft!).

I know there are tricks I can play with formatting (hide cell boundaries
etc), or I could enter the 2 integers as a decimal number and access the
integer & decimal parts separately. eg if I want to enter 5 & 2, I enter
5.2, then use the integer function to 'split' it into 2 parts later.

Are there any facilities within Excel 2007 I don't know about that might
help ?

Thanks, and sorry if this has been a daft question

K