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
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