PC Review


Reply
 
 
=?Utf-8?B?U3RpbGxfbGVhcm5pbmc=?=
Guest
Posts: n/a
 
      10th Oct 2004
I need to know if there is a way to conver t a cell value from 123456 to
1234.56. This value is a nuber not text.
 
Reply With Quote
 
 
 
 
JulieD
Guest
Posts: n/a
 
      10th Oct 2004
Hi

type .01 in an unused cell and copy it
select the numbers you want to change and choose
edit / paste special / multiply
and click the Ok button.

if you want to be able to enter 123456 into a cell and have it change
automatically to 1234.56 choose tools / options / edit / fixed decimal
places and set it to 2.

However, this will affect all numbers entered in any workbook in excel.

Cheers
julieD

"Still_learning" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I need to know if there is a way to conver t a cell value from 123456 to
> 1234.56. This value is a nuber not text.



 
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
Re: Mass covertion from faction odds to decimal odds Living the Dream Microsoft Excel Programming 1 10th Dec 2012 03:41 PM
Re: Mass covertion from faction odds to decimal odds Ben McClave Microsoft Excel Programming 0 7th Dec 2012 03:29 PM
Covertion Frame to Text Box Pauba Microsoft Word New Users 6 22nd Feb 2012 09:57 PM
Changing the function color covertion (unsafe) =?Utf-8?B?VG9tSEw=?= Microsoft C# .NET 1 26th Oct 2005 10:04 PM
covertion KIM Microsoft Access 1 2nd Mar 2004 11:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:25 PM.