Don't change text to numbers

M

meganckk

I want to replace the character "-" into "." in cells formatted as text

eg 0060-1003 must become 0060.1003

i already unchecked in error checking : numbers stored as text

if i do it manually it is ok but because i want to do it by replace
to . and then it becomes 601003

How can i prevent this
 
J

Jim May

Use a temporary "helper-column (a new inserted column)" let's say Column B:
and in Cell B1 enter =SUBSTITUTE(A1,"-",".") where A1 has your
0060-1003. Copy B1 down, then Copy B:B to B:B & use Paste-Special-Values;
Delete Column A:
 
P

Peo Sjoblom

You can use help cells and a formula like

=SUBSTITUTE(A1,"-",".")

copy down or across, then copy them and edit>paste special as values over
the old values
Then delete the help cells



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top