Number formatting issue

[Guest]

I have table with extensive entries (which I inheriited) that are formatted
as general numbers (ie 92.1 or 10.6) when they really are percentages. I am
adding current data to them, but the cut and paste process brings the new
data correctly, as percentages. I have tried changing new entries to match
by dropping the percent sign, but that doesn't do it, and I have tried
changing the old data to percents, but it formats them incorrectlt (ie 71.6
becomes 7160%) I am not a mathmetician - and maybe there isn't any way to
work this out, but I am having to hand enter every number. Any help out
there??? Thanks

 

[Guest]

Hi,

The following is a way to convert your old numbers. In an unused cell type
1.0%
Decrease the decimal place to 1 if required. Copy that cell and select all
of the values you wish to convert (Hold CTRL key down if required). Go to
Edit>Paste Special and choose Multiply. Click OK.

HTH,
Matt

 

[Guest]

Before copying in the new percentages try this on the old data:

Assume that the 'old percentages' are in column A and start on row 1. In B1
just type =A1/100, and drag that all the way down to the bottom of your 'old
percentages' list. Then, copy the data in column B and paste only the values
(right click -> paste special -> Values) into column A. Then format them as
percentages and it should work out.

- Dave