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

This looks very useful, thanks,


KK



"Gary''s Student" wrote in message
...
You can use the =CHOOSE() function to pick from several differenc values
in a
single cell. Say we might want cell B9 to have the value 12 or 5674
or -33.

=CHOOSE(A1,12,5674,-33) depending on the value we put in A1.


Another option is to use a Data Validation pull-down.
--
Gary''s Student - gsnu2007j


"KRK" wrote:

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