how do i make a semicolon appear in every cell
 

how do i make a semicolon appear in every cell
 

You can make a Macro:

Sub AllSemicolon()

Cells.Select
Selection.Value = ";"

End Sub


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570525

how do i make a semicolon appear in every cell
 

Or select the range you want
type the semicolon
hit ctrl-enter
to fill all the selected cells with that character.

paul wrote:

--

Dave Peterson