fraction to text on excel

Hi all
i need to upload a large ammaunt of data to a database
but in some cases when convert to text a fraction 1 1/2   displays as  1.5, i convert it to text but in the addres bar displays in some cases the decimal format when i need all in fractional format, is any way to do so?
tsm
ErnestoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

if you need to convert the numbers into text, then you can use a formula like this:

=TEXT(A1,"# ?/?")

copy the result and paste special > values to get the text value instead of the formula.

cheers, teylyn
0
 
jayneeIT ManagerCommented:
You are putting this large amount of data into an excel spreadsheet, not a database, right?  What version of excel, and how are you getting it in? eg Excel 2007 using the menu item Data/From Text ?
0
 
ErnestoAuthor Commented:
Yes thats the case, even when i format all in text and pase only values in some cells in the addres bar shows as example 5.5  besides 5 1/2 that was the original value input, and when im exporting to the db exports 5.5  is exel 2007 but the file is saved as excel 2003 because the engine that i deploy in vb needs that version
Please help in here!!!
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
ErnestoAuthor Commented:
think got it with your solution teylyn
0
 
jayneeIT ManagerCommented:
I'm glad to hear it.
0
 
ErnestoAuthor Commented:
tsm,
regards
edo
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.