How do I keep the zeros in front of numbers when i split a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am splitting a cell in the cell is dix00001
I need to split it from the first three letters, and when I do I get dix in
one cell and a 1 in the second cell and I need 00001 in the xecond cell. I
have tried formatting the column to text and general.
Help!!!
 
Either format it as 00000

or get it with

=TEXT(RIGHT(A1,5),"00000")
 
If you split using data>text to columns you can set text format in step 3
under column data format

Regards,

Peo Sjoblom
 
Hi,

You can also achieve this through the format cells option in the format
menu. Select thr cell and in custom number formats, go to Generel and
replace it with "0000"General

Regards,

Ashish Mathur
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
VBA Multiple Line handling with Split() 1
How can I keep a zero (0) at the front of a set of numbers. 2
How do you split a cell in half? 3
Word Removing unwanted "lines" within a MS Word 10 table 1
Displaying zeros in cells 2
How to count the maximum number flanked by zeros 9
Splitting Text from single cell in column across multiple Columns 3

Back
Top