Convert to Numbers from Smart Icon - Won't save in Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! How can I get something that seems to only work from a Smart Icon menu
to be saved as steps in a macro???

I am trying to get a very complicated macro to work that I have to break
down into different parts and it keeps failing because I can't get the macro
to record the Convert to Numbers action from the Smart icon. I have a column
of text comments that need to be converted so I can do a subtotal on them.
They are actually the dollar amount of their monthly donation but it's the
only option for entering it.

Any thoughts would be so welcome...
 
I'm not sure what a smart icon menu is, but why can't you just format the
cells as numbers via the Format menu? Recording a macro will capture that
sequence of steps.
 
I'm not sure what a smart icon menu is, but why can't you just format the
cells as numbers via the Format menu? Recording a macro will capture that
sequence of steps.
 
You've obviously not been stuck with MS's new way to format text numbers -
lucky you! You can't just format them anymore. If it were that simple. I'd
still have hair. :o)
 
You've obviously not been stuck with MS's new way to format text numbers -
lucky you! You can't just format them anymore. If it were that simple. I'd
still have hair. :o)
 
Are you talking about XL 2007? Why not just right-click the cells and select
format that way?
 
Are you talking about XL 2007? Why not just right-click the cells and select
format that way?
 
Well, I don't know if they will let me do it again in 2007 but not in 2003.

And I'm sure the non-profit I work for isn't going to run out and buy it
just because some programmer at MS didn't think this through.

Now, if you want to buy Office 2007 for us with a volume license, I'm sure
your donation to IOCC in Baltimore would be tax-deductible as well as greatly
appreciated. :o)
 
Well, I don't know if they will let me do it again in 2007 but not in 2003.

And I'm sure the non-profit I work for isn't going to run out and buy it
just because some programmer at MS didn't think this through.

Now, if you want to buy Office 2007 for us with a volume license, I'm sure
your donation to IOCC in Baltimore would be tax-deductible as well as greatly
appreciated. :o)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Text to Numbers in a Macro 3
smart tags 3
Redefining the $ icons format 5
Cheap Smart Lighting Strips 17
Smart Heating Controls - your thoughts? 2
Word to Excel: Export comments with text and line number 0
Macros & "Convert to Number" 5
Access Issue, Macro Single Step, Error 3270 0

Back
Top