custom data in cells

  • Thread starter Thread starter robjs
  • Start date Start date
R

robjs

Can anyone recommend a way that I can store custom (i.e. 'application'
data in an Excel cell? As an example, the cell might contain (an
display) the value 'January', but behind the scenes, I'd like to stor
some arbitrary value (ints if it matters) like '12' that I can set an
retrieve programatically.

Is there a reasonable way to do this? As always, any help if very muc
appreciated.

Thanks in advance,

- Ro
 
Hi
in your example simply enter a date (like 1-1-2004) and format this
cell with the custom format "MMMM"

In a formula you can get the month number with =MONTH(A1)
 
I guess I wasn't clear enough when I stated the question. Th
information I'm storing generally has nothing to do with months -
have arbitrary text data in cells, and want to store some additiona
piece of information describing that data in the cell as well. Th
information I'm storing isn't something that can be inferred from th
cell content via formula.

To generalize, the cell might contain the string "Fred", and I want t
be able to store the additional integer '49' along with it somehow s
that it can be retrieved programmatically.

Thanks again,

- Ro
 
Hi Rob
this is difficult. One way: use the comment feature and access the
comment contents within your code.
 
Back
Top