Cell formatting

I'm having a problem with Excel (Office 2004) - the worksheet won't accept
specified formatting. For instance, though I've set the type to 'Date' in a
column, and told it (for example) to express the number entered as
'3/14/01', it returns a five-digit number. Similarly, currency values are
returned as integers, '300' rather than '$300.00'. Any help out there?

Thanks -

Gene


Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

If this happened to me in xl for windows, I'd try:

tools|options|view tab
and make sure formulas weren't checked.

But I'm not sure how that works in Office 2004.

If you don't get a good reply here, you may want to post in:
news://msnews.microsoft.com/microsof...c.office.excel



Gene Hawkins wrote:
>
> I'm having a problem with Excel (Office 2004) - the worksheet won't accept
> specified formatting. For instance, though I've set the type to 'Date' in a
> column, and told it (for example) to express the number entered as
> '3/14/01', it returns a five-digit number. Similarly, currency values are
> returned as integers, '300' rather than '$300.00'. Any help out there?
>
> Thanks -
>
> Gene
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com

--

Dave Peterson