Absolutely :)

•› U+255B .75
•œ U+255C .50
•� U+255D .25


"Rick Rothstein" wrote:

I'm pretty sure we can write a macro for you ... can you post the conversion
chart (Unicode character numbers against the fractional values you want it
to be)?

--
Rick (MVP - Excel)


"CliffG" wrote in message
...
Thanks in advance for your help.

In the original database the symbols represented fractions, i.e., ¼, ½, or
¾. I replace these with their decimal equivilents .25, .50, .75. They
are
contained in two columns only, in this case G and I. I basically want
save
it in that format. The saved spreadsheet is ultimately imported into
another
database.

As I mentioned, I can do it fine by pasting the symbols from character map
into "find" and typing in their replacement values. I can save the
spreadsheet, import it later, everything is right. When I try to record
the
steps in the macro, it just doesn't record it correctly. When I run the
macro it doesn't find anything to replace because it's looking for "+"
instead of the symbols.

Thanks again.

"Rick Rothstein" wrote:

Can you give us a hint of what you want to replace them with? You say
"numbers"... what numbers and how are the numbers related to the symbols
(for example, are they their ASCII code)? Is replacing them with numbers
all
you want to do to them, or is that in intermediate step on the way to
some
other functionality? Also, are these symbols confined to specific columns
(if so, which ones) or can they be anywhere within your data?

--
Rick (MVP - Excel)