Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Monks
 
Posts: n/a
Default Display a digit before or after the decimal point in another cell

I want to be able to display the number that is so many spaces to the left
and right of the decimal point. Example: 1234.56 How do I put the
second digit to the left of the decimal point (number 3) in a different cell
in Excel? How do I put the first digit to the right of the decimal point
(number 5) in a different cell in Excel? What function would I use?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Display a digit before or after the decimal point in another cell

=(MOD(A1,10^3)-MOD(A1,10^2))/(10^2) will get you the digit three to the left.
Adjust all three exponents up/down by one to move one digit left/right.

"Robert Monks" wrote:

I want to be able to display the number that is so many spaces to the left
and right of the decimal point. Example: 1234.56 How do I put the
second digit to the left of the decimal point (number 3) in a different cell
in Excel? How do I put the first digit to the right of the decimal point
(number 5) in a different cell in Excel? What function would I use?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default Display a digit before or after the decimal point in another cell

If number is in A1, the second digit to the left of the decimal is extracted
with =MOD(INT(A1/10),10)

If number is in A1, the first digit to the right of the decimal is extracted
with =INT(MOD(A1*10,10))
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Robert Monks" <Robert wrote in message
...
I want to be able to display the number that is so many spaces to the left
and right of the decimal point. Example: 1234.56 How do I put the
second digit to the left of the decimal point (number 3) in a different
cell
in Excel? How do I put the first digit to the right of the decimal point
(number 5) in a different cell in Excel? What function would I use?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Monks
 
Posts: n/a
Default Display a digit before or after the decimal point in another c

Good morning,

When I tried the formula I got the #NAME? reponse. EXCEL changed the
formula to:

=ToiNTEGER(MID(tOsTRING(B3),3,1))

Thanks,

Bob

"Linker IT Software" wrote:

I want to be able to display the number that is so many spaces to the left
and right of the decimal point. Example: 1234.56 How do I put the
second digit to the left of the decimal point (number 3) in a different
cell
in Excel? How do I put the first digit to the right of the decimal point
(number 5) in a different cell in Excel? What function would I use?


I have created a set of additional worksheet functions in an addin called
litLIB. I am using the ToString and the ToInteger functions in my litLIB
addin and the MID Excel function together to display the third digit in your
number. I trust that printing the other numbers individually is easy to
achieve:

=ToInteger(MID(ToString(B3),3,1))

If you are interested in litLIB you can find it he
www.oraxcel.com/projects/litlib

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Linker IT Software
 
Posts: n/a
Default Display a digit before or after the decimal point in another c

Hi Robert,

You probably have not installed litLIB yet. You can get it from my site
www.oraxcel.com/projects/litlib.

litLIB will add the ToString and ToInteger functions among another 100 or so
other functions.

Hope this helps,

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com

"Robert Monks" schreef in bericht
...
Good morning,

When I tried the formula I got the #NAME? reponse. EXCEL changed the
formula to:

=ToiNTEGER(MID(tOsTRING(B3),3,1))

Thanks,

Bob

"Linker IT Software" wrote:

I want to be able to display the number that is so many spaces to the
left
and right of the decimal point. Example: 1234.56 How do I put
the
second digit to the left of the decimal point (number 3) in a different
cell
in Excel? How do I put the first digit to the right of the decimal
point
(number 5) in a different cell in Excel? What function would I use?


I have created a set of additional worksheet functions in an addin called
litLIB. I am using the ToString and the ToInteger functions in my litLIB
addin and the MID Excel function together to display the third digit in
your
number. I trust that printing the other numbers individually is easy to
achieve:

=ToInteger(MID(ToString(B3),3,1))

If you are interested in litLIB you can find it he
www.oraxcel.com/projects/litlib

Gerrit-Jan Linker
Linker IT Software
www.oraxcel.com





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
2 queries: Display last cell, and compare two lists Thierry Excel Worksheet Functions 1 September 23rd 05 04:42 AM
MS Excel 2000 Cell Capacity and Data Display RCM-IEWTD Excel Discussion (Misc queries) 3 August 11th 05 05:05 PM
have cell display the word balance when a equals the same amount a jenniss Excel Discussion (Misc queries) 8 February 6th 05 06:06 PM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 02:12 AM
Display actual contents of cell xmasbob Excel Discussion (Misc queries) 1 December 6th 04 06:09 PM


All times are GMT +1. The time now is 10:07 PM.

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

About Us

"It's about Microsoft Excel"