Thread: display formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
S3 S3 is offline
external usenet poster
 
Posts: 1
Default display formula

How do i display a formula or function in the cell next to the one containing
the result.
For example the function =date(2008,1,31) in cell A1 gives me 1/31/2008 in
cell A1. Now in cell A2 I want to show the function displayed as
=date(2008,1,31) instead of the result so that one can see the function next
to the result.

I would be grateful if someone can offer me some help about doing this.

Thanks so much.