LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Quote from help

If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using Add-Ins on the Tools menu.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lisa" wrote in message
...
I looked this up in MS help in Excel and it says to use this:
=convert(A1, "F", "C") a1 being the first cell with a farenheit degree

in
it.
I thought, "What a snap!" but once I hit return I got the old #NAME?

error.
Anyone know what I am doing wrong?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
Convert to Lower case (not with a function) TAJ Simmons Excel Worksheet Functions 2 December 29th 04 10:33 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
Convert Time...!convert tenths of a second Pape Excel Discussion (Misc queries) 2 December 16th 04 10:17 AM
Is there a formula to convert numbers to written text in Excel? LZC Excel Worksheet Functions 3 November 27th 04 08:10 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"