| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zeroes omitted from the end of imported currency
=A1*100
-- David Biddulph "Craig Ellis" <Craig wrote in message ... Hi, I am importing some values into an Excel Spreadsheet from a .txt file example imported values a 47.80 1,089.90 I need to format these like so: 4780 108990 The problem I am having is that it Excel removes the zero from the end of the amount leaving me with: 478 & 10899 Can anyone help me with this problem? Thanks very much Craig Ellis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a zig zag representing omitted values? | Charts and Charting in Excel | |||
| eliminating trailing zeroes imported into word document from excel file | Excel Discussion (Misc queries) | |||
| Currency Symbols in custom formats when imported from HTML? | Excel Discussion (Misc queries) | |||
| F5 function for zeroes? | Excel Worksheet Functions | |||
| How do I format currency field in Excel 2000 w/o 2 extra zeroes? | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
