If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom Number Format...
I have a number/text that I want to apply a custom format to, but am not sure
if it is possible. The number/text starts as 12K52E1, and I would like to apply a number format to always change it to 12K-52-E1. Is it possible? |
#2
|
|||
|
|||
Not possible to manipulate text like that using a number format,
if there were only numbers one could use something like 00"K"-00-"E"0 I suspect though that you get this text strings so one way assuming that the numbers of characters always are 7 you can use a help formula =LEFT(A1,3)&"-"&MID(A1,4,2)&"-"&RIGHT(A1,2) then copy and paste special as values in place Regards, Peo Sjoblom "whitmore0112" wrote: I have a number/text that I want to apply a custom format to, but am not sure if it is possible. The number/text starts as 12K52E1, and I would like to apply a number format to always change it to 12K-52-E1. Is it possible? |
#3
|
|||
|
|||
You can't apply a format like that to text, it has to be numeric. You can
always use formula to create that data in that format if that is acceptable though, or even have a bit of code run through and change it all. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "whitmore0112" wrote in message ... I have a number/text that I want to apply a custom format to, but am not sure if it is possible. The number/text starts as 12K52E1, and I would like to apply a number format to always change it to 12K-52-E1. Is it possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional format number | goss | General Discussion | 1 | October 8th, 2004 03:53 PM |
Automatically set number format | Norm2000 | General Discussion | 2 | September 5th, 2004 03:57 PM |
Number Format Problem | Lana | Worksheet Functions | 6 | February 16th, 2004 08:57 PM |
Number format problem in CSV files | Mervyn Thomas | Worksheet Functions | 3 | January 14th, 2004 05:31 PM |