LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 109
Default How can I correct a custom format?

I've created a custom format to display a number as 1111 2222 3333 4444.
However when I enter in the 16 digits, the 16th turns to 0.

Any ideas?
 
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
My Excel 2000 changes the format of my numbers, how do I correct? Dell Excel Discussion (Misc queries) 3 February 13th 07 11:16 PM
hiding % characted in the Y axis using custom format tony Charts and Charting in Excel 6 August 31st 06 11:38 PM
Custom Format for User Defined Function [email protected] Excel Discussion (Misc queries) 5 August 7th 06 11:27 PM
adding custom format Kelly Excel Discussion (Misc queries) 2 June 29th 06 03:35 PM
Custom Cell Format Will Not Save Correctly szyzygy Excel Worksheet Functions 3 July 21st 05 11:55 PM


All times are GMT +1. The time now is 06:49 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"