Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 23rd 14, 07:17 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2014
Posts: 11
Default Calling Claus B.

I have a spread sheet set up in Excel 2007 and in column AT I have a list of
numbers. All are lined up nicely on the extreme left of the column except
one, the number 2, which sits in line with the others until I leave the box
and it then jumps to the extreme right of the column. All but this one has
a little green triangle in the top left hand corner of its box. Can you
remedy this? I should add that I have made the default setting for
text/numbers.


  #2   Report Post  
Old April 23rd 14, 07:25 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,731
Default Calling Claus B.

Hi Emrys,

Am Wed, 23 Apr 2014 19:17:47 +0100 schrieb Emrys Davies:

I have a spread sheet set up in Excel 2007 and in column AT I have a list of
numbers. All are lined up nicely on the extreme left of the column except
one, the number 2, which sits in line with the others until I leave the box
and it then jumps to the extreme right of the column. All but this one has
a little green triangle in the top left hand corner of its box. Can you
remedy this? I should add that I have made the default setting for
text/numbers.


real numbers are right in the cell. If the numbers are on the left side,
the numbers are text formatted. Therefore you see the green triangle.
Write a 1 in an empty cell, copy this cell, select your numbers and
choose paste special = Multiply.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #3   Report Post  
Old April 23rd 14, 08:41 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2014
Posts: 11
Default Calling Claus B.


"Claus Busch" wrote in message
...
Hi Emrys,

Am Wed, 23 Apr 2014 19:17:47 +0100 schrieb Emrys Davies:

I have a spread sheet set up in Excel 2007 and in column AT I have a list
of
numbers. All are lined up nicely on the extreme left of the column
except
one, the number 2, which sits in line with the others until I leave the
box
and it then jumps to the extreme right of the column. All but this one
has
a little green triangle in the top left hand corner of its box. Can you
remedy this? I should add that I have made the default setting for
text/numbers.


real numbers are right in the cell. If the numbers are on the left side,
the numbers are text formatted. Therefore you see the green triangle.
Write a 1 in an empty cell, copy this cell, select your numbers and
choose paste special = Multiply.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


Claus,

Sorry, but that did not work. I got to Paste Special and Paste as Unicode
Text was revealed. I clicked OK and a little suitcase parked itself in the
correctly placed '2' cell. As you will have gathered I am not much into
this so would you kindly talk me through it with a little more detail. =
Multipy did not reveal itself. In short I have 4 columns of numbers namely
at columns B, D, AT and AS and all of them except one are on the left hand
side of the cell. The first two columns have numbers 21/12 or similar and
the last two columns comprise single or double digits. Thanks.

  #4   Report Post  
Old April 24th 14, 06:50 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,731
Default Calling Claus B.

Hi,

Am Wed, 23 Apr 2014 20:41:35 +0100 schrieb Emrys Davies:

Sorry, but that did not work. I got to Paste Special and Paste as Unicode
Text was revealed. I clicked OK and a little suitcase parked itself in the
correctly placed '2' cell. As you will have gathered I am not much into
this so would you kindly talk me through it with a little more detail. =
Multipy did not reveal itself. In short I have 4 columns of numbers namely
at columns B, D, AT and AS and all of them except one are on the left hand
side of the cell. The first two columns have numbers 21/12 or similar and
the last two columns comprise single or double digits. Thanks.


can you send me the workbook to my email address?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #5   Report Post  
Old April 24th 14, 04:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2014
Posts: 11
Default Calling Claus B.


"Claus Busch" wrote in message
...
Hi,

Am Wed, 23 Apr 2014 20:41:35 +0100 schrieb Emrys Davies:

Sorry, but that did not work. I got to Paste Special and Paste as
Unicode
Text was revealed. I clicked OK and a little suitcase parked itself in
the
correctly placed '2' cell. As you will have gathered I am not much into
this so would you kindly talk me through it with a little more detail. =

Multipy did not reveal itself. In short I have 4 columns of numbers
namely
at columns B, D, AT and AS and all of them except one are on the left
hand
side of the cell. The first two columns have numbers 21/12 or similar
and
the last two columns comprise single or double digits. Thanks.


can you send me the workbook to my email address?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


I tried to send a copy of the workbook in an e-mail message as an attachment
but I got the error: General mail failure. Quit Microsoft Office Excel,
restart the mail system and try again. I also tried Print Screen but failed
there and that was the case when trying to 'send' it from my documents. I
may have to settle with the text format. I note that the conversion from
text to numbers works in this practice site, but it did not work properly
for me. http://www.digdb.com/excel_add_ins/c..._text_general/





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
For Claus Busch: From OP Re Quote Marks. Bob[_19_] Excel Discussion (Misc queries) 0 November 14th 13 02:43 PM
Claus code works on my data not on OP's data Howard Excel Programming 2 August 14th 13 08:10 PM
For Claus From OP: Bob[_19_] Excel Discussion (Misc queries) 1 December 12th 12 07:53 PM
Calling SUB Peter Longstaff Excel Programming 2 February 23rd 04 09:04 PM
Calling all MVP's DennisE Excel Programming 3 January 23rd 04 10:24 AM


All times are GMT +1. The time now is 03:00 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017