I have been working a spreadsheet and I just noticed that in one of my
rows which has fractions in it (for example, 08/1, 11/1, 12/1) a few of
the cells have been converted into a date.
Like, 8/1 is now 8/1/2006 and in the cell it comes up as 1-Aug, 11/1 is
now 11/1/2006 and in thje cell it comes up as 1-Nov
Fractions that are higher than 12 like 14/1 and 15/1 are still the
same, I am guessing this is because we don't have a 14th or a 15th
month in a year :rolleyes:
I tried to reformat these sells to a number but that did not help. All
it did was that It solved the date i.e. 11/1/2006 turns into 30922.00
Is there any way in excel where my fractions won't turn into dates or
get solved?
thanks

Signature
bombayterror
Gary''s Student - 08 Jan 2006 20:09 GMT
Select the cells and pull-down:
Format > Cells.. > Fraction and enter up to two digits (at least) before
entering information into the cells.

Signature
Gary's Student
> I have been working a spreadsheet and I just noticed that in one of my
> rows which has fractions in it (for example, 08/1, 11/1, 12/1) a few of
[quoted text clipped - 14 lines]
>
> thanks
bombayterror - 08 Jan 2006 20:30 GMT
yup that worked. Thanks a lot.
Had one more question.
I have a column of numbers which are percentages
1%
2%
3%
4%
and so on
is there a way to format this column as a number so that I can
eliminate the % sign without converting the %age into a decimal form?

Signature
bombayterror
Barb Reinhardt - 08 Jan 2006 20:59 GMT
Format -> Cells -> Number tab ->Category Number -> Choose the # of decimal
places you want to use.
> yup that worked. Thanks a lot.
>
[quoted text clipped - 9 lines]
> is there a way to format this column as a number so that I can
> eliminate the % sign without converting the %age into a decimal form?
bombayterror - 08 Jan 2006 21:27 GMT
Got it. Thanks a lot for the help

Signature
bombayterror