#1   Report Post  
Old January 28th 05, 11:13 PM
Bill M.
 
Posts: n/a
Default add 2 decimal places

I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that?

  #2   Report Post  
Old January 28th 05, 11:15 PM
Gordon
 
Posts: n/a
Default

Bill M. wrote:
I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that?


Type in the number 10 in a spare cell. highlight it, select "copy" then
select the column you wish to change, right-click on it, select "paste
Special" and under "Operation" choose divide.

HTH


--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
  #3   Report Post  
Old January 28th 05, 11:21 PM
Peo Sjoblom
 
Posts: n/a
Default

Do you still want them to be text?

If not

=--(A1)/100

if text

=TEXT(--(A2)/100,"@")


Regards,

Peo Sjoblom



"Bill M." wrote:

I have a column of numbers which were imported as text and need to have the
last two places changed to decimals. How do I do that?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 07:07 PM
ROUND DATA TO 2 DECIMAL PLACES roy in sunbury New Users to Excel 1 January 12th 05 04:33 AM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 06:29 PM
Significant figures (not decimal places) Gene Solomon Excel Worksheet Functions 2 December 9th 04 10:42 PM
Decimal places in Excel 2003 EXCELNCBOY Excel Worksheet Functions 6 November 5th 04 04:39 PM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017