Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello, I need to add an apostrophe to each cell in a long column of numbers.
I do not want to format them as text or format them as custom - our system requires the apostrophe at the beginning of the cell. My question is - is there a way to format one cell with the apostrophe and then copy that apostrophe down to the other cells?? or can someone write me something that will allow me to do it quickly? I want to avoid having to go into each cell and put the apostrophe in! Thank you in advance.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Apostrophe in Numbers | Excel Discussion (Misc queries) | |||
Apostrophe Infront of Text & Numbers | Excel Worksheet Functions | |||
adding a hidden apostrophe to a cell | Excel Discussion (Misc queries) | |||
adding apostrophe macro? | Excel Discussion (Misc queries) | |||
Adding an apostrophe | Excel Discussion (Misc queries) |