Changing value from $ to Yen


Posted by George on October 23, 2000 11:58 AM

I have a sheet with lots of scattered data points which
are in US $. I would like to replace all of those with
a converted Yen value.

Is this possible?

Also, does anyone know of bugs in the password part
of excel that do not allow a Japanese user to save
the file? Even if that person knows the password.
Any tricks to get around it? I can modify and save
a password protected workbook but a Japanese
user cannot?

thanks for any help

Posted by Loren on October 23, 2000 12:43 PM


Enter your multiplier in a cell and copy it. Then
highlight the target numbers, paste special multiply.
All target numbers will be replaced.



Posted by george on October 23, 2000 1:15 PM

I know i can do it that way but as i mentioned the data
is scattered and there are numbers where i do not
want the conversion.

any other thoughts?

thanks