Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I insert an ' in front of many rows of numbers?
I have a column of numbers 1,800 rows long that needs an ' in front of every
row. How do I do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I insert an ' in front of many rows of numbers?
Sub MakeText()
Dim cell as Range for each cell in Range("F1:F1800") cell.Formula = "'" & cell.Text Next End Sub -- Regards, Tom Ogilvy "jszuch" wrote in message ... I have a column of numbers 1,800 rows long that needs an ' in front of every row. How do I do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I insert an ' in front of many rows of numbers?
See response in .misc
-- HTH RP (remove nothere from the email address if mailing direct) "jszuch" wrote in message ... I have a column of numbers 1,800 rows long that needs an ' in front of every row. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS | Excel Worksheet Functions | |||
Insert symbol in front of value | Excel Discussion (Misc queries) | |||
How to auto insert rows in a list of numbers | Excel Discussion (Misc queries) | |||
INSERT THE SAME WORD IN FRONT OF EACH ROW | Excel Discussion (Misc queries) | |||
how do I insert an ' in front of many rows of numbers? | Excel Discussion (Misc queries) |