fractions to date

V

Vivian H.

I am copy and pasting an htm form to an excel file. All works well except one
field. On the htm it is a fraction - 4/4 , 3/2 etc. It converts to date of
4-April, 2-March. My ultimate goal is to keep it as a fraction or break it
into 2 fields- a= 4, b=4. Then I will convert it to a .csv file and import
to a third program. I am using Excel 2007. I don't have a clue how to
accomplish this. Please help.
 
S

Sheeloo

One way is as follows;

Suppose you have got the dates (after wrong conversion) in Col A...

Enter this in B1
=TEXT(A1,"m")
to get the month as a number

Enter this in C1
=TEXT(A1,"d")
to get the date

Or this
="'" & =TEXT(A1,"m") & "/" & =TEXT(A1,"d") to get it as a fraction
(formatted as TEXT)
 
V

Vivian H.

Thank you! This does exactly what I need.
Sheeloo said:
One way is as follows;

Suppose you have got the dates (after wrong conversion) in Col A...

Enter this in B1
=TEXT(A1,"m")
to get the month as a number

Enter this in C1
=TEXT(A1,"d")
to get the date

Or this
="'" & =TEXT(A1,"m") & "/" & =TEXT(A1,"d") to get it as a fraction
(formatted as TEXT)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top