| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting a cell
I am creating an excel ASCII file data source for importing to another
program. I need to express the rates as a percentage as follows (10.25% into format 10.2500). Excel 2000 |
|
#2
|
|||
|
|||
|
With 10.25% in A1, in another cell =A1*100
Copy, Paste Special Values and overwrite the original, Regards, Alan. "BKT Hopeful" <BKT wrote in message ... I am creating an excel ASCII file data source for importing to another program. I need to express the rates as a percentage as follows (10.25% into format 10.2500). Excel 2000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Special cell formatting | Excel Discussion (Misc queries) | |||
| Formatting a cell to populate on a certain date | Excel Worksheet Functions | |||
| Conditional Formatting Cell and Row | Excel Worksheet Functions | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
Linear Mode
