-
hi xld,
I'll try to explain it better.
If I put the value 4/10 in a cell the result will be:
value=0,2
format="# ?/?"
displayed=2/5
I want it displayed as "4/10" so I change its formatnumber in "# ?/10"
If I insert in the same cell the fraction "18/20" then I get:
value=0.9
format="# ?/10"
displayed="9/10" BUT I WANT IT DISPLAYED AS I ENTERED IT!
So I want a fraction displayed as I entered it.
I can convert it as string but I'll lose calculation.
Enough clear?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules