Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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???

EXCEL thinks 5/64 is a date (May 1, 1964), and it is giving

you a representation of the date in "Number" format.

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

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

apostrophe.

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.

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.

Related Topics:

- Automatic update of Function return value.
- send a value from one text box to another form using request.form method
- Sum values entered into text boxes
- Wait function and Invisible function
- Wait function and Invisible function
- formatting text which is in text formula
- Convert code from excel 2000 vba to excel 2003 vba
- Excel 2003 compatibility pack
- Forcing Excel 2003 to open file when Excel 2007 also installed
- 2003 - Trigonometry puzzle
- Ratio of positive and negative text in learning dataset for text classification?
- File formats ( Excel 2003 & Excel 97 ) ?
- Excel 2003
- 2003 - drawing shapes
- 2003 - ActiveSheet.Calculate Problem
- VBE Missing References in Excel 2003
- XL 2003 - Precision printing
- 2003 - Setfocus on userform
- 2003 - Rounding
- 2003 - Userform combobox behaviour
- Conditional Formatting in Access 2003
- 2003 - Moving to a formula address
- Excel 2003 - Looking at jpgs on the web
- Select Duplex Printing-Excel 2003
- 2003 - Problem with dates