Forum Discussion
Complex Cell Format, Maybe!!!
Hi,
I'm in the eyecare profession and we make use of vision measurement (visual acuity) standards, and these are supposed to be indivisible fractions, but here are what I's faced with:
- Unless I format the cell to text, excel will either divide the fraction or convert it to date via the date picker I'm using what other means can I use?
- I'd like to use this fraction like 6/18 or 20/60 to count in the count function, would this be possible?
This is just the start, I want to solve this first and then see how it goes.
Thanks for your guidance.
Cheers.
13 Replies
Good question! Excel often reads entries like “6/18” as dates or fractions. Try setting the cell format to Text before typing, or add an apostrophe (‘6/18) so Excel keeps it as plain text. You can then split or calculate values in another column if needed.
checkout this https://estateagentsdagenham.co.uk/ also, can help you more.Hi everyone.
Thanks for the assistance so far.
The superscript is becoming something of a need for me, and right now I'm trying to use it to distinguish between two products in a dropdown.
Here are the products:
- Contact Lens Tp,
- Contact Lens Rx.
Tp: Therapeutic, and
Rx: Prescription.
I can get this into the cell, but in the dropdown, it no longer appears as a superscript when I select it. I'm trying to make this work so that I can create a database and use it as a guide for bulk ordering from a preferred manufacturer.
I'd appreciate a constructive insight into this.
Thank you.
Just a thought for the final output: use your Excel data as the source, but send that data through the MailMerge process into Word, where the superscript and subscript could readily be used.
Thank you for your constructive feedback, but I'm not exporting it to MS Word; I'm retaining the information in Excel.
Thanks.
Interesting... I'll try this ASAP.
Thank you.
How about use text format plus helper column:
1. Enter your values as text (e.g., '6/18 with an apostrophe).
2. In a helper column, extract or count based on the text.=IF(A1="6/18", 1, 0)alternatively you could just enter the 2 values in adjacent cells
if you need a 'report' you can then show it using = A1 & "/" & B1
Thanks for the good alternative, but it has a little challenge. You see the visual acuity (6/12...), they tend sometimes to have superscripts, and when I follow the method above, it returns the superscript to an ordinary number.
E.g.: 6/12-2, the -2 is supposed to be in superscript format.
How can I remedy that, or is it impossible???
Thanks for your assistance.
