How do I format an imported number 15034 to $150.34

J

JE McGimpsey

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.




"Format an imported number in Excel" <Format an imported number in
(e-mail address removed)> wrote:
 
F

Format an imported number in Excel

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

Ken Wright

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.
 

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

Excel does not accept text format! 0
How to change font & size of (all) citation numbers? 7
How can the font and size of (all) citation numbers be altered? 1
Word macro that can call cells out of Excel for a find and replace 0
Identical looking cells 2
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
New computer, how do i move outlook 365 ENTIRELY? 0
color just "*" in a number cell 0

Top