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 fo...
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.