displaying a number like 1/8,000

  • Thread starter Thread starter Thrava
  • Start date Start date
T

Thrava

I'm type 1/8000 in a cell and it converts it to decimal.
I like to keep it in this fractional format

How do you make it do that? I did choose fraction under
cell formating menue, but it won't display things like 1/
100,000
 
Perfect
Thank you much
-----Original Message-----
Hi
try formating the cell with the custom format
# ?/???????

--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

1-52 pages, 8,000 employee numbers 3
Cell displays #'s incorrectly 3
How to format numbers as architectural fractions (1/16,1/8,1/4 ) 5
Conditional formatting of number format? 2
tiny discrepancies in fixed-point numbers 3
show fractions rounded up to nearest 1/16th inch 15
In Excel 2003 display 8/16 as 1/2 and 4/16 as 1/4 2
Insert symbol as a header for a column 1

Back
Top