| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
preserving zeros in spreadsheet
Hi There, I've been working on this for what seems like forever.
Basically, what I am trying to accomplish is the copying of a Accounting field, $ 4501.00, into a file I will then be converting into a fixed width file in Access. I can't seem to preserve the trailing zeros when I move the data. It just copies over as such: 4501. This fixed width file will be used for posting dollars so 450100 needs to post and not 4501. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preserving "trailing" zeros from csv file | Excel Discussion (Misc queries) | |||
| Preserving trailing zeros for a fixed width file | Excel Worksheet Functions | |||
| formula for spreadsheet, avoiding zeros? | New Users to Excel | |||
| What formula is used to replace blanks in spreadsheet with zeros? | Excel Worksheet Functions | |||
| Displaying leading zeros in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
![Danielle[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
