 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2005How 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? > If you just want to format it: > [quoted text clipped - 6 lines] > "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.  SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.