Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

fraction getting convered into date

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bombayterror - 08 Jan 2006 19:11 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.