adding a ' ie 'xxxx instead of xxxx

C

cclambie

Hi

Firstly, Hello, my first post! So thanks if you can help

I would like to add a ' to a range of cells to ensure my previous
validation continues working.

Basically. Even though the cells are formated in Text format,
validation isn't working for some reason without the 'xxxx in the
cell.

does anyone know how to add this?

I have tried concatenate, but i then have to go down and f2, enter in
all the cells??

Would really appreciate your help.
 
D

Dave Peterson

I don't think that this will help.

If the value is already in the cell, you won't be reapply the validation.

And if you're getting it ready for the next change, then the user could avoid
typing the apostrophe -- so that won't help.

Maybe just formatting the cell as text would be sufficient to catch the next
change--again, it won't help the current value in the cell.
 
C

cclambie

ok...this then didn't work...damm it.

so used this code to add the leading apostrophe and it appears to work
now

'Sub fixanzsic()
'*****Currently not in use, to update ANZSIC list to text format

'Dim strg As String

'Do Until ActiveCell.Value = ""

'strg = ActiveCell.Value

'strg = "'" & strg

'ActiveCell.Value = strg

'ActiveCell.Offset(1, 0).Activate

'Loop

'End Sub
 
Top