Replies

Perhaps this code could be adapted. It was something I created a long time ago for chemical formulas. Select the cells with the text and all the numbers are converted to subscripts.

Steve

Code:

Option Explicit
Sub SubscriptNumbers()
  Dim rCell As Range
  Dim sWord As String
  Dim sCharacter As String
  Dim x As Long
  For Each rCell In Selection
    sWord = rCell.Value
    For x = 1 To Len(sWord)
      sCharacter = Mid(sWord, x, 1)
      If sCharacter >= "0" And _
        sCharacter <= "9" Then
        rCell.Characters(Start:=x, Length:=1).Font _
          .Subscript = True
      End If
    Next x
  Next rCell
  Set rCell = Nothing
End Sub

This works really nicely. Thank you very much.

I was afraid of that, but I had sort of hoped it could be done.

Well, off to the graphic programs!

Thanks for the help.

Because it is in a column with other dates in various formats, and I need to be able to sort it by date from time to time, I will stick with what I can get.

But, if in the future I need to do this, I will save and remember the technique.

Bob Mathews: Thanks for the information. I had totally forgotten about that option.

The only way I know is by changing your system clock !

That will work, but may give some problems with, for instance, your AV program – at last until you change it back.

Giving Troubles it does (with apologies to Yoda). I just thought I would ask in case someone had stumbled upon something.

Sorry to be obtuse. Yes, Search does select the cell with the found value. However, the “highlighting” (to coin a term) is not much different from the rest of the spreadsheet. And, in my case, I have the spreadsheet zoomed to 85% or even smaller. This makes finding the selected cell difficult to see. So, I was looking for a way to tell Excel to make the found cell more obvious.

Interestingly, if I choose “Find All” and scroll through these choices, the selected cells are highlighted with the standard heavy border, just as when working normally. But if I simply choose “Find Next”, it is almost impossible to distinguish the choice from the rest of the background.

Well, I have Open Office. I’m too cheap to pay the bucks for Billy’s software.

HOLY MACKERAL THERE BATMAN!!!

WOW!!!

I have never seen this “Find and Select” before. And I thought I was a reasonably good Excel user in spite of my lack of macro programming. And, the command is something I had not seen before. [PS–I like your use of the old WordPerfect description of keystrokes]

EDIT: I just tried it. There is one problem. In Reality, many of my cells have formulas. This technique does not carry down the formula. But for other parts of the worksheet, this is a miracle worker.

Here is the test workbook. And thanks again for offering to help.

Double Palm Slap.

Yes, A4 was a typo.

And “Match entire cell contents” is something that I have seen time and time again. Brain freeze and Senior Moment combined.

Thanks for the information.

Our computers are locked down big time. The only backup program I have is ntbackup.exe. It works OK, and I am saving to a network. I can live with that. Since I am only saving my data, it only takes about 3 minutes.

Since ntbackup must be started from “run…”, which I can drag to the desktop, I would like to modify the shortcut to start the program, and if possible add the proper parameters such as type and location into the command line. I used to remember how to do this trick, but it has been a long time since I played with these items.

Let it never be said that a large bureaucracy really makes sense! I work for one of the world’s largest;
–To prevent problems from outside sources, the computer is locked down (I had to have a tech install a couple of things in the handicapped assistance area; that part of windows is not shown on my computer.
–I have to regularly (annually) take a program on computer security

They do say keep it on the network, but they insist on saying that it should be stored and worked from the network directly. Yet they do not force backups, and they freely allow storage locally.

So, NTBACKUP it is; or maybe PKZIP.

RetiredGeek: I think you meant 0.0##% [Otherwise the 1.3% would display as 0.013.]

JohnD1: Personally I do not like removing just trailing zeroes as it makes the precision representaion variable. I would go for custom number format of 0.0% and have 1.300% and 1.312% both display as 1.3% instead of having 1.300% display as 1.3% and 1.312% display as 1.312%. Unless specified the typical presumption is ±.5 in the last decimal so 1.3% suggests (with no otehr information) a number between 1.25-1.35%, where 1.300% suggests that it is between 1.2995-1.3005%

Steve

Oh my! Custom formatting!

(Know why I have a flat forehead? I ask the question; I get the answer; I slap my forehead with my palm saying “Of Course! Why didn’t I think of it?”)

Thanks to all!

And, yes I am quite familiar with the varying precisions implied by dropping the final zero(s). This is not of my doing; I am merely the messenger at this point. (What I am doing is analyzing data sent to me; I need to present my report in the manner that the data was given me. They drop final zero–I drop final zero.)

In the Insert Symbol dialog, Special Characters tab, choose “No-width optional break”. This will insert a double-box symbol if youhave the View All turned on, but acts as a break if needed. (This is useful for allowing a break in some text situations, but be aware that if you use it within a long URL, the symbol will mess up the validity of the URL.)

AHA!!! So THAT’S where it is. Earlier discussions had mentioned this, but I could not find it.

Excel is far from perfect when it comes to WYSWYG

See post [post=457495]Wordwrap[/post]

Tom D

YUP!! And indeed that is why I was grumping. I already knew the answer, but I was a little frustrated so I had to vent. I felt better after doing it.

I suppose a database would be more useful, but the only thing I have is the rest of the Micro$oft suite here, and for my purposes, Access is a major problem. Ah, for a good windows flat database without bells & whistles (an updated PCFile would be wonderful). And, since this computer is locked down for security purposes, I would not be able to install it.

Some of the routers allow you to do this. And, for those that have the capacity, you can specify WHICH computers are affected, and have different setups for different computers. And, just do it; tell the kiddiewinkies that there must be something wrong with the computer/internet/router when they cannot access the interweb.