LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Carlos
 
Posts: n/a
Default Multiple formats for a single cell value.

I wish to use a formula or to format a cell value so as to only display
certain characters of the actual value. For example in the case of a value
123-45-6789, I would wish to only display 6789, or the last 4 digits. Is
there a way that this is possible?
 
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 to sum the values of a single cell from multiple worksheets Ratman Excel Worksheet Functions 3 September 20th 05 06:35 PM
Multiple coin flips in a single cell igor eduardo küpfer Excel Worksheet Functions 7 September 13th 05 03:09 PM
Maximum Number of Cell Formats Jim Allen Excel Discussion (Misc queries) 4 April 19th 05 07:07 PM
multiple validation in a single cell whowatwerwyhow Excel Discussion (Misc queries) 5 April 15th 05 02:37 PM
Can vlookup return multiple matches in a single cell? cchristensen Excel Discussion (Misc queries) 3 December 2nd 04 01:56 AM


All times are GMT +1. The time now is 06:31 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"