Posted to microsoft.public.excel.worksheet.functions

Pete_UK

Posts: n/a

Function displays as text, doesn't return result or error

You might have calculation mode set to manual - go to Tools | Options |
Calculation (tab) and ensure that Automatic is checked.

Hope this helps.

Pete

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding "and" to Spellnumber code	Ken G.	Excel Discussion (Misc queries)	10	July 22nd 06 12:53 PM
Displays the number in text. (One thousand two hundred thirty four	Ashish Patel	Excel Worksheet Functions	1	March 20th 06 09:27 PM
Number format	Mani K	Excel Discussion (Misc queries)	2	December 28th 05 11:01 AM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
Amount or Numbers in Words	ron	New Users to Excel	6	December 24th 04 07:32 PM

All times are GMT +1. The time now is 09:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us