Solved

# 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
297 Views
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.
0
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)

Thomas
0

## Featured Post

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â€¦
###### Suggested Courses
Course of the Month17 days, 13 hours left to enroll