Hello Garry,
I appreciate your support. My entire workbook is formatted as "Text"
and when I run the macro it converts (.140) to -0.14 and I see the
error telling me "Number Stored as Text". Is there a way I can work
around this issue?
Thanks
I don't get this conversion behavior when I 'set' the cells to 'Text'
on the 'Number' tab of the FormatCells dialog. Perhaps you could
'deliberately' format all cells before replacing...
Cells.NumberFormat = "@"
Cells.Replace...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion