In Excel 2003, how would you convert a column of numbers with 2 decimal positions such that the result is the removal of the decimal and the number values are muliplied by 100?

Posted on 2012-08-23
Medium Priority
Last Modified: 2012-08-23
I am working with Excel 2003.

How would you convert a column with numbers with 2 decimal positions such that for ex:
00000000050.00 becomes 0000000005000 by removing the decimal point and multiplying by 100. I need to retain the lead zeros because I import these records into a mainframe file that expects lead zeros.
Question by:zimmer9
1 Comment
LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 38325823
if all your "numbers" have two decimal positions, format the column as text and do a find replace to replace . by nothing (leave the field blank)


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question