format a decimal number to nondecimal numbers

J

jun

i am using excel to create upload files for certain applications in the
office and it is working correctly. i have a predicament though as there is
an application where i need to create an upload file which requires me use a
nondecimal format. the raw data i have are all in decimal format. what is the
best way for me to change the data from decimal to nondecimal. is there a
format method that i can use?
 
R

Ron Rosenfeld

i am using excel to create upload files for certain applications in the
office and it is working correctly. i have a predicament though as there is
an application where i need to create an upload file which requires me use a
nondecimal format. the raw data i have are all in decimal format. what is the
best way for me to change the data from decimal to nondecimal. is there a
format method that i can use?
Click to expand...

More information is needed.

Formatting will only change the way the number appears in Excel. It will not
change the nature of the underlying value in the cell.

What do you mean by a "nondecimal number"?

Of the various meanings I can think of, I would guess that you'll have to ROUND
the value to zero decimal places; possibly after MULTIPLYING the value by 100.


--ron
 
M

MartinW

Hi Jun,

If you are talking about removing the decimal point and leaving
the numbers intact, you may be able to use Find and Replace.

Select all of your data
Find (put . in the find box)
Replace (leave the replace box empty)
Click replace all

HTH
Martin
 
Top