B
bdunk
I have a spreadsheet that has a sum formula at the end of a column. Th
problem is that the last 7 or 8 values being summed seem to be text.
However, if you go to format cells they show up as numbers. In Offic
XP you can simply click on the Green arrow in the upper left han
corner and select convert to number. This fixes the problem and all i
well. In 2000 this function is not available. Is there a way t
convert these values without having to retype all the values in?
Thanks Bdun
problem is that the last 7 or 8 values being summed seem to be text.
However, if you go to format cells they show up as numbers. In Offic
XP you can simply click on the Green arrow in the upper left han
corner and select convert to number. This fixes the problem and all i
well. In 2000 this function is not available. Is there a way t
convert these values without having to retype all the values in?
Thanks Bdun