LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default excell number formatting

I am trying to take 3 cells and merge the information into one cell while
changing the formatting.

enter 23, 45, 670 into 3 cells. Have a return of 023-045-670 in one cell.
I need to use this # as if it were 23045670 and be able to sort and add to
it. I know how to mege the cell it's the return of 023 from 23 that seems
most problematic.
 
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
Excell-Protecting sheet formatting Didas Excel Worksheet Functions 0 March 22nd 07 10:14 PM
Excell formatting Jeffery Excel Discussion (Misc queries) 3 March 4th 07 04:32 AM
Number Entry in Excell viper2000ss Excel Discussion (Misc queries) 1 December 6th 06 07:08 PM
How can I link a cell in Excell and keep the same formatting? Dolly Excel Worksheet Functions 1 June 7th 06 12:30 AM
How do I get excell to indicate when a number is out of a set ran. Jeff Harmon Excel Worksheet Functions 3 March 8th 05 03:19 PM


All times are GMT +1. The time now is 04:05 PM.

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

About Us

"It's about Microsoft Excel"