How do I format an imported number 15034 to $150.34

If you just want to format it:

Format/Cells/Number/Custom $0\.00

Note that this doesn't actually change the value. To do that requires
either a function in another cell or a macro.




In article <F0FEC5D1-33BD-42C9-AF5A-1570328F7FB9@microsoft.com>,
"Format an imported number in Excel" <Format an imported number in
Excel@discussions.microsoft.com> wrote:

Could you instruct me as to how to insert a macro to complete this, or tell
me where to learn?

"JE McGimpsey" wrote:

> If you just want to format it:
>
> Format/Cells/Number/Custom $0\.00
>
> Note that this doesn't actually change the value. To do that requires
> either a function in another cell or a macro.
>
>
>
>
> In article <F0FEC5D1-33BD-42C9-AF5A-1570328F7FB9@microsoft.com>,
> "Format an imported number in Excel" <Format an imported number in
> Excel@discussions.microsoft.com> wrote:
>

All your data follow EXACTLY the same pattern, ie the last 2 digits in EVERY
case should be decimal? if so then type 100 in an empty cell and then copy
that cell. Select all your data and do edit / paste special / values &
divide. Now just apply a normal format.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Format an imported number in Excel" <Format an imported number in
Excel@discussions.microsoft.com> wrote in message
news:F0FEC5D1-33BD-42C9-AF5A-1570328F7FB9@microsoft.com...
>