Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amber - 11 Jun 2007 17:13 GMT

I have a document with multiple calculations in it and for some reason today,
one of the tabs that has calculations is showing only the actual calculation
and not the result. The formatting is just not working. I even have a
column that is set up with a "date" format and formatting is not correct. It
is showing a bunch of numbers.

The other tabs with calculations in the same document are fine.

Any ideas????

Thanks.

Reply to this Message

Ron Coderre - 11 Jun 2007 17:34 GMT

It sounds like you may that sheet set to display only formulas....

Try this:

Hold down [Ctrl] and press the [~] key (in the upper left of the keyboard)

That will toggle Formula Display On/Off

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> I have a document with multiple calculations in it and for some reason today,
> one of the tabs that has calculations is showing only the actual calculation
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message

Amber - 11 Jun 2007 17:38 GMT

That worked wonderfully. Thanks you so much. I was getting a little
frustrated. :)

> It sounds like you may that sheet set to display only formulas....
>
[quoted text clipped - 22 lines]
> >
> > Thanks.

Reply to this Message

Toppers - 11 Jun 2007 17:36 GMT

Check the format of the data: it suggests they are TEXT rather than the
required format.

Reply to this Message