PC Review


Reply
Thread Tools Rate Thread

Copy parts of a number

 
 
GeniE
Guest
Posts: n/a
 
      5th Jun 2010
If I have a cell with a digit 123,4567 - how can I copy the content of the
cell to another cell with only two digits after the comma. In other words - I
only want 123,45 to appear in the new cell.

Is there any way to use a "round off" functionality?
 
Reply With Quote
 
 
 
 
L. Howard Kittle
Guest
Posts: n/a
 
      5th Jun 2010
Well, I wonder if it is really a 'number'...?

Seems to be text as written and if 123,4567 copied and pasted from the post
to Excel it shows as 1,234,567.

So pasted in a text formatted cell you can use =LEFT(A1,6) to return 123,45.

HTH
Regards,
Howard

"GeniE" <(E-Mail Removed)> wrote in message
news:9B59BAC2-68E9-4FA1-A17E-(E-Mail Removed)...
> If I have a cell with a digit 123,4567 - how can I copy the content of the
> cell to another cell with only two digits after the comma. In other
> words - I
> only want 123,45 to appear in the new cell.
>
> Is there any way to use a "round off" functionality?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto number for a parts list. Heroplumber Microsoft Excel Misc 2 23rd May 2009 05:54 PM
Auto number for a parts list. Heroplumber Microsoft Excel Misc 0 23rd May 2009 05:38 PM
breaking down a whole number into pre-defined parts.. GD Microsoft Excel Misc 4 2nd Feb 2009 01:21 PM
Split a number in a cell into parts okanem Microsoft Excel Misc 4 21st Aug 2006 03:59 PM
Copy parts of cell Mike Mike Microsoft Excel Misc 1 18th Apr 2006 01:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:34 AM.