Solved

fraction to text on excel

Posted on 2013-01-21
6
363 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
  • 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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