I got problem with typing hyphen in the cell. Every time I type it shows something else like C9, D6 and so on.
I'm looking forward for the help.
I got problem with typing hyphen in the cell. Every time I type it shows something else like C9, D6 and so on.
I'm looking forward for the help.
Type a single quote (') first and then type the hyphen.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Alternatively, format the cell as Text.
Regards, Rob.
Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
cant see why i can type a hyphen in a cell formatted general no problem
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
In fact, Martin is absolutely right (of course)
If you just type a minus/hyphen and press Enter, you will get a hyphen. If you type minus/hyphen and click on another cell, Excel helpfully thinks you are trying to set up a formula and adds the cell reference.
So, now you have three options ... Martin's obviously requires the least effort.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks