using excel windows 98

[jc calling]

i have a table of 100's of figures that are all in text, ie:

12 34 45 56 67 78
56 78 23 78 34 67
23 89 45 78 87 21
each number in it's own cell,

but i have loads of them

how can i get a decimal point in front of all of them, so they all show like
this

..12 .34 .45 .56 .67 .78
..56 .78 .23 .78 .34 .67
..23 .89 .45 .78 .87 .21

i have looked in the cells settings and can not find a way myself, i have
been told to check a box to default the decimal point, but this is when you
have an empty sheet, not when you have already entered the figures.

any ideas.

thanks

Jason

 

[Max]

One way ..

Enter 100 in an empty cell and copy it

Select the table of figs
Click Edit > Paste special > Divide > OK

 

[jc calling]

THANK YOU THANK YOU THANK YOU

cheers mate, well done.

Jason

 

[Max]

Pleasure' Jason !
Glad it worked ..