MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

2003 - TEXT and VALUE functions

  Asked By: Jamil    Date: Oct 10    Category: MS Office    Views: 1073

I have "'5/64" in cell A1.

In cell A2
I have....


And the result is..... In A2..... 23498

Anyone tell me what's happening please???



5 Answers Found

Answer #1    Answered By: Ethan Evans     Answered On: Oct 10

EXCEL thinks 5/64 is a date (May 1, 1964), and it is giving
you a representation of the date in "Number" format.

Answer #2    Answered By: Komal Mohammad     Answered On: Oct 10

I obviously need to "revisit"................

Answer #3    Answered By: Chau Tran     Answered On: Oct 10

you may need to format col A as fractions and then enter 5/64 without the

Answer #4    Answered By: Viheke Fischer     Answered On: Oct 10

It's actually converting it to a DATE (5/1/1964)
then displaying it as the number of days since 1/1/1900

Let me play with it for a bit and see if I can figure out how to handle it.

Answer #5    Answered By: Jeanette Greene     Answered On: Oct 10

Excel thinks it's a date: May 1, 1964

If you enter 5/64 in a cell, Excel will probably convert it to 5/1/1964

To enter the fraction 5/64, you have to enter =5/64.

To get the results you want in A2, try

Didn't find what you were looking for? Find more on 2003 - TEXT and VALUE functions Or get search suggestion and latest updates.