LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Robbie in Houston
 
Posts: n/a
Default Number formatting question

I'm trying to format a column of numbers for USPS tracking numbers.
However, no matter how many different ways I try the custom number format
option, it only picks up the first 15 digits of the 22 digit number, and the
rest display as zeros. It changes my input from a 22 digit number to a 15
digit number with E+21 on the end of it. If it's easier to look at, try
this. The tracking number SHOULD display as:

9101 1288 8230 0160 7398 49

but it ACTUALLY displays:

9101 1288 8230 0160 0000 00

and the cell INPUT BECOMES:

9.10112888230016E+21

It seems to me the easy custom format would be:

#### #### #### #### #### ##

This doesn't work and I've tried about twenty different variations on that
format. I know this is either simple or can't be done but my brain is just
shot. Any help would be awesome.

Thanks,
Robbie


 
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
Cell formatting behaviour question derek Excel Discussion (Misc queries) 3 February 22nd 05 10:17 PM
Number formatting Fred Holmes Excel Discussion (Misc queries) 2 February 21st 05 06:02 PM
Conditional formatting row when cell value is an even number hhunt Excel Worksheet Functions 5 February 2nd 05 09:29 PM
Pivot Table Drill Down Number Formatting Gregg Riemer Excel Discussion (Misc queries) 1 January 4th 05 10:53 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM


All times are GMT +1. The time now is 10:56 AM.

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"