Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default general format

I have a cell that is formated with general formating. it has a number in
it. the cell was populated using a brio query. it appears as 06 left
justified, as if it was formated using text but it is not. when I hit f2 to
change the number to 07 and then hit enter it appeares as 7 right justified,
the way it should. Why does the data appear as 06 and how can I keep it
appearing with the leading 0 and left justified with general formating after
I change it to a differ number?
 
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
General Format to Date Format [email protected] Excel Discussion (Misc queries) 9 December 21st 06 01:44 PM
Format: General - Text - General iturnrocks Excel Worksheet Functions 3 August 11th 06 04:47 PM
excel numbers in general format i cant add cant change format claude Excel Worksheet Functions 2 July 7th 06 08:18 PM
Change general format to US date format woodlot4 Excel Discussion (Misc queries) 3 October 11th 05 12:29 AM
Change General Format to Currency Format Freshman Excel Worksheet Functions 3 July 8th 05 03:42 AM


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