LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Display 0 in the cells...

..

hi all,


i'm trying to show "0" in a cell with successor as any other number.

i don want to convert the cell as text, or to add a hyphen before 0,
like " '05 ".

Please let me know how to solve this.


Regards,
Divy

 
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
Cells display as R5C5. How do I change it to display E5? FinanceTrainer Excel Discussion (Misc queries) 2 December 14th 09 08:27 PM
Display cells(text) in one column based on cells which are present inother column [email protected] Excel Discussion (Misc queries) 1 May 12th 08 01:40 PM
some cells display formulas, some display values mvivelo Excel Discussion (Misc queries) 1 March 27th 08 10:09 PM
display a range of cells editible cells based on matching date Miki Excel Worksheet Functions 0 October 10th 07 03:27 PM
Why does my formula bar display a lengthy string, but my cells display #####? [email protected] Excel Programming 2 August 23rd 06 06:43 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"