View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rachel Costanza[_2_] Rachel Costanza[_2_] is offline
external usenet poster
 
Posts: 12
Default Excel and Busines Objects . .

Hello,

When I try to put date functions in a template exported from business
objects the functions do not work. For example if in cell A1 I use
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"mmmm yyyy") that is what shows up
in cell A1. I have tried to change the cell formats to all available options
and still the date does not display. Any ideas?

Many thanks in advance!

Rachel Costanza