Written by
| Powered by phpBay Pro |
How can I preserve a custom number format and convert a cell to text in Excel?
I've added leading zero's to a batch of data using custom format. I need to change these to text, but when I do, the zero's dissapear! Any help would be great, thanks.
you can use the Text Function: =TEXT(A1,"000000") where the first argument is the cell to convert and the second arguement is how you want the text formatted.
Items Recently Purchased From This Site:
Basset Hound Custom 2-Panel Arch Memorial Plaque -ANY PHOTO-ANY TEXT, Shih Tzu Custom & Personalized License Plate Frame - ANY PHOTO OR TEXT, 2 Deer Head Vinyl Decals with CUSTOM TEXT ANY FONT, 2 VolleyBall Decals with CUSTOM TEXT ANY FONT, 2 soccerball Decals with custom text ANY FONT, 2 Paint Horse Vinyl Decals with CUSTOM TEXT ANY FONT, 2 karate Vinyl Decals with CUSTOM TEXT ANY FONT, 2 Dancing Decals with custom text ANY FONT, 2 BasketBall vinyl decals with custom text ANY FONT, 2 Horse Head Decals custom text ANY FONT AND COLOR, Unique Red Floral Heart Name Any Text Custom 9mm Italian Photo Charm New, Your Info Any Text Or Image Custom 9mm Italian Photo Charm Unique, Schipperke Custom & Personalized Trailer Hitch Cover -ANY PHOTO ANY TEXT, Samoyed Custom & Personalized Mouse Pad- ANY PHOTO - ANY TEXT, Samoyed Custom & Personalized Pillow Case -ANY PHOTO ANY TEXT, Samoyed Custom & Personalized License Plate Frame - ANY PHOTO OR TEXT, Schhipperke Custom Iron & Ceramic Trivet -ANY PHOTO-ANY TEXT, Schanuzer Custom & Personalized Pillow Case -ANY PHOTO ANY TEXT, Pomeranian Custom 2-Panel Arch Memorial Plaque -ANY PHOTO-ANY TEXT, Rottweiler Custom & Personalized Checkbook Cover- ANY PHOTO - ANY TEXT,
| Powered by phpBay Pro |
