Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Adding Dashes in front of text using text formating

When I add a dash in front of text (in text formatting) it doesn't treat it
as text, but adds a cell address in front of the text. How do I add dashes
or hyphens in front of text without this effect?
--
Neal
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default Adding Dashes in front of text using text formating

Precede it with an apostrophe?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Neal" wrote in message
...
When I add a dash in front of text (in text formatting) it doesn't treat

it
as text, but adds a cell address in front of the text. How do I add

dashes
or hyphens in front of text without this effect?
--
Neal



Reply
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
How change dimensions of data label text box in pie chart? Gouden Willem Charts and Charting in Excel 3 March 7th 06 01:11 PM
Conditional formating with TEXT Steve M Excel Discussion (Misc queries) 4 February 18th 06 06:11 PM
Text Formating Duke Excel Worksheet Functions 0 February 15th 06 01:07 AM
Adding a certain text label in a excel chart Tim Charts and Charting in Excel 2 September 28th 05 08:03 PM
Formating a text string? METCO1 Excel Discussion (Misc queries) 2 November 30th 04 07:31 PM


All times are GMT +1. The time now is 10:37 AM.

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

About Us

"It's about Microsoft Excel"