Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 128
Default Insert Character At start of cell

Hi All,

How do I insert the character "-" at the start of each cell in the active
selection?

Thanks

Andi


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Insert Character At start of cell

for each c in selection.cells
c.value="-" & c.value
next c

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
Insert character at beginning of cell without changing contents elle Excel Discussion (Misc queries) 4 April 3rd 23 06:52 PM
Insert a special character in 1st and last position into a cell Mugge New Users to Excel 5 November 6th 07 09:38 PM
how to insert tab character into the cell? kang New Users to Excel 2 July 16th 07 01:01 PM
Does Alt-Enter insert a non-printing character in a cell string? Henry Stock Excel Programming 3 February 23rd 05 09:28 PM
Insert a standard character in a cell of excel. JulieD Excel Worksheet Functions 5 November 19th 04 06:31 PM


All times are GMT +1. The time now is 04:11 PM.

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"