When I type in a division problem, for example: =6/5 Excel converts it to a date (5-jun). how can i get it to return the value ?
2006-11-06 01:23:50 · 5 answers · asked by absynthian 6 in Computers & Internet ➔ Software
Right click on the cell and choose "Format Cells." Make sure that under the Number tab, it is set to "General" or "Number." Also, make sure that you are placing the equals sign (=) before the equation when typing it in. It won't default to a date when you are indicating that it is an equation by using the equal sign (=6/5), but will default to a date without it (6/5). Good luck!
2006-11-06 01:35:53 · answer #1 · answered by Anonymous · 1⤊ 0⤋
there is no need to format any cells, if it's a formula just use:
=sum(6/5)
if you just want it to display 6/5 use:
'6/5
notice the apostrophe before the 6/5, this is what keeps the format.
2006-11-09 15:23:03 · answer #2 · answered by piquet 7 · 1⤊ 0⤋
Format the cell for a number.
2006-11-06 09:31:36 · answer #3 · answered by jbgot2bfree 3 · 1⤊ 0⤋
Go to format cell and choose general or number ...
2006-11-06 09:32:06 · answer #4 · answered by Amethyst Tiger 2 · 2⤊ 0⤋
a quick way. =6.0/5 That won't be interpreted as a date.
2006-11-06 09:25:56 · answer #5 · answered by samw3 2 · 0⤊ 2⤋