Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I format an imported number 15034 to $150.34
|
#3
|
|||
|
|||
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 , "Format an imported number in Excel" <Format an imported number in wrote: |
#4
|
|||
|
|||
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 wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customer Number Format | Excel Worksheet Functions | |||
Telephone number format | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |