Formatting a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
With 10.25% in A1, in another cell =A1*100
Copy, Paste Special Values and overwrite the original,
Regards,
Alan.
 
You must log in or register to reply here.

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

how do i format a cell in Excel to 3 significant numbers 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
More math than excel, but a fun problem 4
Convert Cell Value to ASCII 1
Format Values to specified length 1
Lenght of a decimal part of a number. 4
Easy Steps to Import PST Files to Office 365 0
Assign format from value of another cell? 1

Back
Top