Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fourier, numbers-as-text, and macros.
The output of the Fourier Transform fills most cells as numbers (all those
that are complex numbers), but all those that are real it fills as text(!) The output of the inverse Fourier Transform fills all cells with numbers-as-text(!) My output column is formatted to Number, General. But the inverse FT result is still written as text (they are all real numbers). I need them as bonafide numbers (to be plotted). Converting them to numbers is done by selecting the output cells, opening the error icon on the upper left, and selecting "convert to number". But this last action is not accepted when recording the strokes in a macro. The steps suggested in HELP on "Convert numbers stored as text to numbers" don't work. So: Can the FT routine be set to enter results directly as numbers? If not, how do I convert numbers-as-text to numbers in a Macro? - Neal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Add-in = Fourier Analysis | Excel Worksheet Functions | |||
inverse fourier | Excel Programming | |||
Fourier Series | Excel Worksheet Functions | |||
Fourier Analys | Excel Programming | |||
Fourier Analysis | Excel Worksheet Functions |