I can not get excel to format a cell so when I type in 5-9 it will not change it to 9-May it will just live it 5-9 it is the height of someone
I can not get excel to format a cell so when I type in 5-9 it will not change it to 9-May it will just live it 5-9 it is the height of someone
Last edited by FDibbins; 09-22-2013 at 05:47 PM.
It will see numbers in that format as a date every time. 2 options...
'5-9
5'9
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You can also format cell as text.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for that AlKey, I always forget that 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks