a mac equivalent for asap-utilities

[Greg Henderson]

Hello

Has anyone ever seen a Mac equivalent for www.asap-utilities.com -- a
FREE add in for Windoze users that is nothing less than GREAT ... it has
a huge list of special features for particular needs ...for example I
screen scrape from an old Unix system that puts negative signs BEHIND
the number ...and this program add-in will convert that to the normal in
front placement ( and more than 100 similar special uses)

It is a real pain to transfer from my Mac to a co-workers PC to do the
fix ..love to find it on the Mac.

Regards

Greg Henderson

 

[Jim Gordon MVP]

Hi,

If you import a file that has numbers with the minus signs after the
numbers, then Excel will treat them as text instead of numbers when you
open the text file in Excel.

This cell function will convert a text number into a negative value and
leave the numbers alone
=IF(ISTEXT(A1)=TRUE,VALUE(CONCATENATE("-"&LEFT(A1,LEN(A1)-1))),A1)

Many of the features of the add-in you mentioned are part of standard
Excel. If you come across a specifc need check Excel's help file to see
if Excel already does it. If you can't find what you are looking for the
whole world is here to offer assistance in the newsgroup.

-Jim

 

[JE McGimpsey]

Hello

Has anyone ever seen a Mac equivalent for www.asap-utilities.com -- a
FREE add in for Windoze users that is nothing less than GREAT ... it has
a huge list of special features for particular needs ...for example I
screen scrape from an old Unix system that puts negative signs BEHIND
the number ...and this program add-in will convert that to the normal in
front placement ( and more than 100 similar special uses)

It is a real pain to transfer from my Mac to a co-workers PC to do the
fix ..love to find it on the Mac.

I've not seen a compilation of useful utilities, like asap, for MacXL -
and I don't like them in WinXL either - there are lots of compilations
that have one or two functions that I'd use. The rest of the functions
either aren't of interest, or they work differently than I'd like them
to.

You could put the macro found here:

http://www.mcgimpsey.com/excel/postfixnegatives.html

in your Personal Macro Workbook. You could also put it in a file and
save the file as an add-in.