Number Formatting

jcc0810 · May 7th, 2002, 12:52 PM

I am having somewhat of a small problem in Excel. I have over 6000 rows of data in non-decimal format, for example (45). What I want to do is convert these cells to a decimal version in hundredths (.45) and a percentage version (45.00%). The problem comes in when i try to format the cells, there seems to be no conversion for hundredths only conversion for thousandths, so the conversion looks like this (.045). When I go into Format>Cells>Number>Custom and try the conversion that way i still get the same output. Any advice? Thanks.

Mark W. · May 7th, 2002, 12:58 PM

Convert your values by dividing by 100... Just enter 100 into a cell, Copy it and then use Edit | Paste Special Values with the Divide operation.

Formatting never changes the internal representation of a value -- it only changes how a value is displayed!

[ This Message was edited by: Mark W. on 2002-05-07 12:01 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 12:52 PM	#1
jcc0810 New Member Join Date: May 2002 Location: James Chronowski Posts: 1	I am having somewhat of a small problem in Excel. I have over 6000 rows of data in non-decimal format, for example (45). What I want to do is convert these cells to a decimal version in hundredths (.45) and a percentage version (45.00%). The problem comes in when i try to format the cells, there seems to be no conversion for hundredths only conversion for thousandths, so the conversion looks like this (.045). When I go into Format>Cells>Number>Custom and try the conversion that way i still get the same output. Any advice? Thanks.

May 7th, 2002, 12:58 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Convert your values by dividing by 100... Just enter 100 into a cell, Copy it and then use Edit \| Paste Special Values with the Divide operation. Formatting never changes the internal representation of a value -- it only changes how a value is displayed! [ This Message was edited by: Mark W. on 2002-05-07 12:01 ]