using excel windows 98

  • Thread starter Thread starter jc calling
  • Start date Start date
J

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
 
One way ..

Enter 100 in an empty cell and copy it

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