Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make one cell equal to another
I just moved from Office 2000 to Office 2003. I do a report that is sorted
by time zone. On the 2000 version in the time zone colum I used the following formula: =tzone(f2) Column F contained the state. I would then do an edit and fill down. The column would then fill in the appropriate time zone for the state shown in column f In version 2003 this formula no longer works. How do I ge the desired result in Ver 2003 |
#2
|
|||
|
|||
Hi
tzone is not a build-in function. You probably had an addin installed on your old PC. -- Regards Frank Kabel Frankfurt, Germany Deb Blackshaw wrote: I just moved from Office 2000 to Office 2003. I do a report that is sorted by time zone. On the 2000 version in the time zone colum I used the following formula: =tzone(f2) Column F contained the state. I would then do an edit and fill down. The column would then fill in the appropriate time zone for the state shown in column f In version 2003 this formula no longer works. How do I ge the desired result in Ver 2003 |
#3
|
|||
|
|||
Here's a page that may provide possible solutions, if you can't find the
original addin. http://www.tushar-mehta.com/excel/timezone.htm tj "Deb Blackshaw" wrote: I just moved from Office 2000 to Office 2003. I do a report that is sorted by time zone. On the 2000 version in the time zone colum I used the following formula: =tzone(f2) Column F contained the state. I would then do an edit and fill down. The column would then fill in the appropriate time zone for the state shown in column f In version 2003 this formula no longer works. How do I ge the desired result in Ver 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
Make a cell blank? | Excel Worksheet Functions |