Logo 
Search:

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

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

In cell A2
I have....

=VALUE(A1)

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

Anyone tell me what's happening please???

Share: 

 

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

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

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

To get the results you want in A2, try
=LEFT(A1,SEARCH("/",A1)-1)/RIGHT(A1,LEN(A1)-SEARCH("/",A1))

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




Tagged: