Solved

fraction to text on excel

Posted on 2013-01-21
6
365 Views
Last Modified: 2013-01-22
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
0
Comment
Question by:edo60
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 38803701
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
 
LVL 7

Expert Comment

by:jaynee
ID: 38803761
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
 

Author Comment

by:edo60
ID: 38803908
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:edo60
ID: 38803918
think got it with your solution teylyn
0
 
LVL 7

Expert Comment

by:jaynee
ID: 38804117
I'm glad to hear it.
0
 

Author Closing Comment

by:edo60
ID: 38806219
tsm,
regards
edo
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question