Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How do I keep the 0 at the beginning of a number, ex. 090?


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,345
Default How do I keep the 0 at the beginning of a number, ex. 090?

Pre-format the cells as text or precede it with an apostrophe

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"linds.hope" wrote in message
...




Reply
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
How can I keep zeros in the beginning of a number in excel Starprincess Excel Discussion (Misc queries) 2 December 8th 06 05:07 PM
Is there away to add a zero to the beginning of number string? Anthony Excel Worksheet Functions 5 March 15th 06 10:49 PM
How do I get Excell to recognise 0 at the beginning of a number? The Wonder From Downunder Excel Discussion (Misc queries) 4 February 4th 06 11:57 AM
Zero at the beginning of a number Zeros at the front of numbers Excel Discussion (Misc queries) 4 April 11th 05 02:58 PM
How to display the number zero at the beginning of a number when . Calvin New Users to Excel 2 March 8th 05 08:16 AM


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

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"