Thread
:
Need Help With A Very Simple Macro
View Single Post
#
3
Don Guillett
Posts: n/a
As always, post your efforts to help us help you
--
Don Guillett
SalesAid Software
"Amca" wrote in message
...
I download from a database that provides ratios in the following format "
0.95 :1" which is formatted as text. I tried to write a macro that would
delete the " :1" so I could convert the cell to a number and use it in
calculations. Every time I run the macro it changes the cell to the exact
number that was in the original cell I used when creating the macro. Does
anyone know what I am doing wrong?
Reply With Quote