N8iveIT

Research Engineer - Electrical

d-glitch

Senior Developer

ste5an

"Batchelor", Developer and EE Topic Advisor

Qlemo

<div>
If you format the cell as number, and enter 
<pre><code id="code-20-42905625-1">=2-56</code></pre>
 what do you get?
</div>


If you format the cell as number, and enter

=2-56

what do you get?

<div>
Using VBA you can do something like this, which in this case adds an an apostrophe at the start of every used cell on the sheet.<br />
<br />

<pre><code id="code-20-42905630-1">Dim cel As Range
For Each cel In ActiveSheet.UsedRange 
        cel.Value = &quot;'&quot; &amp; cel.Value 
Next cel </code></pre>
</div>


Using VBA you can do something like this, which in this case adds an an apostrophe at the start of every used cell on the sheet.



Dim cel As Range
For Each cel In ActiveSheet.UsedRange 
        cel.Value = "'" & cel.Value 
Next cel 

<div>
Prior to entering values set the format of that column to Text and it will just show what you enter so entering 2-56 will show as that and not be converted to a date.
</div>


Prior to entering values set the format of that column to Text and it will just show what you enter so entering 2-56 will show as that and not be converted to a date.

Test your restores, not your backups...

Bill Prew

<div>
Thanks, I'm better now. &nbsp;Bad case of unexpected operator overloading.<br />
<br />
Subtract &nbsp; 8<b>-</b>32 = 11902.00<br />
<br />
Divide: &nbsp; &nbsp; &nbsp; &nbsp;8<b>/</b>32 = 0.25 &nbsp; (no equal sign required)<br />
<br />
Divide: &nbsp; &nbsp; &nbsp; &nbsp; 8<b>/</b>1<b>/</b>32 = 11902.00<br />
Twice
</div>


Thanks, I'm better now.  Bad case of unexpected operator overloading.

Subtract   8-32 = 11902.00

Divide:        8/32 = 0.25   (no equal sign required)

Divide:         8/1/32 = 11902.00
Twice

<div>
<div class="content wysiwyg-content">
Strange behavior with Excel - 2-56 = 20486 &nbsp; and &nbsp; 8-32 = 11902 ????<br />
<br />
I was trying to type ANSI Machine Screw Sizes. &nbsp;They are all weird. &nbsp;<br />
<br />
I can get it work with a leading quote or space, but how is Excel coming up with these numbers?
</div>
</div>


Strange behavior with Excel - 2-56 = 20486   and   8-32 = 11902 ????

I was trying to type ANSI Machine Screw Sizes.  They are all weird.  

I can get it work with a leading quote or space, but how is Excel coming up with these numbers?

Strange behavior with Excel - 2-56 = 20486   and   8-32 = 11902 ????

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.