LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default minus signs, or dashes in a formula or hyperlink

=HYPERLINK("file:///W:\Courtney\Recon\LnRec-8-09.xls#2003-N!A1","September
2009 Reconciliation")

The above is obvisouly a hyperlink; however, the formula is not functioning
properly. It does take me to the worksheet "2003-N" but instead of "landing"
in cell A1, it lands in cell B32. Additionally, I receive an error message
that says the reference is not valid. This also happens with any sheet that
is named with a dash or minus sign in the name. I feel certain it has to do
with that dash, as the formula works perfectly with worksheets that have no
dashes/minus signs in the name.
Can anyone assist me?

Thanks

--
Allan
 
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
No plus or minus signs to left of subtotals Staceyglow Excel Worksheet Functions 2 August 19th 09 03:03 AM
How do I get Plus and Minus signs in my additions and subtraction TKM New Users to Excel 1 October 24th 06 06:11 PM
MINUS SIGNS REMOVAL Rebecca New Users to Excel 2 November 24th 05 12:07 AM
strip minus signs from right to left Heather Excel Discussion (Misc queries) 2 April 21st 05 05:52 PM
I want to get brackets round my figures not minus signs Peru Excel Discussion (Misc queries) 3 February 3rd 05 09:30 PM


All times are GMT +1. The time now is 06:59 AM.

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"